Every Power BI user knows or should know the star schema concept. And then apply it! But if you are not a data engineer or SQL server admin, how are you going to save your remodeled data in a real Datawarehouse. Well if your company enables you to use Dataverse, then a citizen developer might be able to build a Datawarehouse him/her self in Dataverse. Including incremental refresh.
During this session I will show you how to do this and also talk about the pro's and con's. And compare it with Dataflows as you mat know them from the Power BI service.
I will start with an short introduction to the concepts of Dataverse: Tables, Keys, Relations, Security.
I will then build dataflows to:
- create a Customer Dimension table with surrogate Key with and without history (SCD0 and SCD2)
- create a Sales Fact table in which I combine Order header and Order details. And the Order Freight amount will be allocated to the related details lines during the process.
Both tables will then be saved to Dataverse.
After the creation of the tables, I am going to apply Incremental refresh in order to only load the newer records during future refreshes. And update the changed record within the refresh period.
I will use a public ODATA version of Northwind traders database as my transactional source system.
Finally I will connect my Power BI to the Dataverse tables
For your information: Dataverse is an Enterprise scale relational database solution with very sophisticated security options. And it is a central part of the Power Platform.

Möchte das mal testen. Sprache auch Deutsch