Reputation: 21
We have a requirement where we have to fetch data from Power BI dataset and transform the data and then produce the data again in Power BI Workspace so that I may consume that in PBI.
-> Is there any way I may connect my Power BI Dataset in ADF.
-> Once the data is fetched can I use Power Query to work on dataset in ADF.
-> Where to store that data: in ADLS or in Azure BLOB or may I save this data in SQL directly?
-> Once I have transformed the data can i publish my gold data in Power BI Workspace?
Upvotes: 0
Views: 8274
Reputation: 4945
There is PowerBI REST API to execute queries: Datasets – Execute Queries
you can access the power bi dataset via managed identity or service principal authentication.
You can leverage Dataflows to do the transformation
The query w.r.t 3rd aspect really depends on your architecture.You can preserve it anywhere
Upvotes: 2