04-30-2017 06:02 AM - last edited 10-25-2018 08:55 AM
This dashboard shows the capacity of Power Query engine to build in-memory a
relational database from multiple API call and some ETL operations. Power Query directly calls the TULEAP REST API to build entities thanks to the "Power BI Web Connector".
After some ETL operations in Power Query to prepare data, you can build your own relationship model, thanks to Power Pivot user interface. Here I generated a generic fact table (cf. OLAP Star Model like) to allow PowerView to cross-join data from different entities (cf. specific API calls).
Then, you can use your creativity to build smart dashboards.