A Python script in an Azure Function is used to retrieve data from a REST API. Azure Data Factory is used for orchestration. The Python script 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 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…

Duurt het te lang?

Laad het document opnieuw

| Openen in nieuwe tab