Extract data from semantic models using ADF or similar?

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.