'How to create Power BI dataset (including fact & dim tables, relationship etc.) automatically at scale?
I have a PBI dataset which I created using PBI Power Query on my local laptop. The PBI dataset modeled the gross data into fact the dim tables. Let's say that the source data is an invoice table, the power query break the table to fact and dim table, create the connections etc. Then I create a PBI report to visualize this data. I am looking for a way to create the data model automatically.
As I picture it it will be a JSON file which include the data source parameters (details , credential and other parameters) and a script which include the data model logic as I created on Power Query). When I get a new invoice table from another data source all I need to do is: update the JSON file and run the script which will setup the data model automatically. for example: take the invoice table, create the fact and dim tables ad create the connections. N problem using other Azure solution such as Azure analytical service etc. I have the coding skills, so fee free to suggest API all everything. Thank you, Tal
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|