Forum Discussion
Extract data from semantic models using ADF or similar?
We have several semantic models in our PBI Premium environment.
We've done a lot of ETL work to get the data into those models.
We have some lookups that we would like to be able to extract from those models and reuse in other systems.
Is there a way to use ADF or Power Automate or some ETL tool to connect to the Power BI Semantic Model as a data source and extract data out of it?
Basically instead of loading data into a semantic model I want to suck data out and dump it in an SQL table or someplace.
Hello sasdfasdfsad
Yes its possible to query PBI dataset using ADF and store to your desired location such as Sql table, adla etc
ADF can execute DAX queries against a Power BI dataset using the Power BI REST API. This is done by configuring a Web Activity in an ADF pipeline to make HTTP POST requests to the `/executeQueries` endpoint of the API
https://www.mattiasdesmet.be/2023/11/09/use-powerbi-apis-in-azure-data-factory
please accept this answer and give kudos if this is helpful
Hi sasdfasdfsad,
Thanks for posting your query in Microsoft fabric community forum.Thanks nilendraFabric for your valuable response! Yes, it is possible to extract data from Power BI Semantic Models using Azure Data Factory (ADF) by executing DAX queries via the Power BI REST API.
Additionally, here are some key points to consider:
- Ensure you have the necessary permissions and authentication setup (Azure AD, service principal, or user-based authentication) to execute queries against the Power BI dataset.
- Extracting large volumes of data via the API can be slower than direct database queries. Consider optimizing your DAX queries and using incremental extraction where possible.
- Alternatively, you can also use Power Automate with the Power BI connector to extract data periodically and store it in a SQL table or another destination. If you are using Azure Analysis Services, you can use the XMLA endpoint to connect via tools like SSIS or Logic Apps.
For more details, refer to the official Power BI REST API documentation.
If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.
2 Replies
Hi sasdfasdfsad,
Thanks for posting your query in Microsoft fabric community forum.Thanks nilendraFabric for your valuable response! Yes, it is possible to extract data from Power BI Semantic Models using Azure Data Factory (ADF) by executing DAX queries via the Power BI REST API.
Additionally, here are some key points to consider:
- Ensure you have the necessary permissions and authentication setup (Azure AD, service principal, or user-based authentication) to execute queries against the Power BI dataset.
- Extracting large volumes of data via the API can be slower than direct database queries. Consider optimizing your DAX queries and using incremental extraction where possible.
- Alternatively, you can also use Power Automate with the Power BI connector to extract data periodically and store it in a SQL table or another destination. If you are using Azure Analysis Services, you can use the XMLA endpoint to connect via tools like SSIS or Logic Apps.
For more details, refer to the official Power BI REST API documentation.
If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.Hello sasdfasdfsad
Yes its possible to query PBI dataset using ADF and store to your desired location such as Sql table, adla etc
ADF can execute DAX queries against a Power BI dataset using the Power BI REST API. This is done by configuring a Web Activity in an ADF pipeline to make HTTP POST requests to the `/executeQueries` endpoint of the API
https://www.mattiasdesmet.be/2023/11/09/use-powerbi-apis-in-azure-data-factory
please accept this answer and give kudos if this is helpful