Second article from a series on [ #Office365 ] Power BI 2.0 :
The architecture of the new Power BI can be summarized by the following schema:
[Updated on 2015-07-14] Added the personal Gateway and detailed the apps
In this picture, we can see from left to right:
- The sources: basically there are three types of sources in Power BI, files, databases and services.
- The service in itself where you can define three types of objects : datasets, reports and dashboards
- The destinations : Dashboards and reports can be consumed in three ways,
The data sources can be shown in this picture:
They are separated in three categories:
- Files (which formats are Excel and Power BI)
- Services which are prepackaged models of data for popular services (like Google Analytics or GitHub)
- Big Data and More (for Azure DBs and SQL Server Analysis on-premises)
A new direct connectivity to Apache Spark (especially suited for Big Data scenari) has been annouced. Query performance over a Hadoop dataset can be 100 times faster with Spark.
The 3 main concepts of Power Bi are:
- Reports and
A dataset is basicaly a set of tables. Each table can be the result of a Power Query query. All tables of in a dataset can be completaed with relationships, measures, …
You can combine several datasets in a report and again you can combine visualizations from several reports on a dashboard (this can’t be done in Power BI Designer by only in the service).
One of the best feature of Power BI is that everything you can do in the service is accessible via the API. So the API described here: Overview of Power BI REST API
You have access to 3 types of objects:
So you can use PowerShell to inject data in real time to your datasets.
- Announcing Power BI general availability coming July 24th
- Over 500,000 unique users from 45,000 companies across 185 countries helped shape the new Power BI
- Power BI for Developers
- MSDN Overview of Power BI REST API