user2845758
user2845758

Reputation: 21

How to connect to POWER BI DATSET in Azure data factory

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

Answers (1)

Nandan
Nandan

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.

My blog : https://datasharkx.wordpress.com/2022/11/03/copy-data-from-power-bi-through-azure-data-factory-synapse-pipeline-via-managed-identity-authentication-part-4/

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

Related Questions