Dashboard as a Service for multiple customers using solely Power BI.
Power BI Dataflows are used to retrieve data from a REST API. Multiple M queries are used to retrieve data from multiple customers. The Dataflow is also used to transform and append the data. Transformations included parsing nested JSON files and applying business logic by e.g. adding descriptive columns. The result is several dataflows containing fact- and dimension tables.
The facts and dimensions are loaded into Power BI Semantic Models where Dynamic Row Level Security (RLS) is applied. The conditions within RLS are such, that each customer will only see their own data when visiting the Power BI App.
A Power BI App is used to distribute insights in business processes about sales, purchases, offers and work force management. “Audience” within the Power BI App is used to further augment existing authorization (in this case, the RLS implemented in the Semantic Model).
Bezig met laden…
Laad het document opnieuw 
Openen in nieuwe tab