Forum Discussion
Automated extract from datawarehouse - possible?
Hi Anonymous ,
It sounds like you are trying to search a automated and efficient way to extract data from your Power BI semantic model. Please review the following links and check if that is what you want.
REST API:
Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Power Automate:
How to Export Power BI Report to Excel using Power Automate?
Solved: export data from power bi visuals to excel automat... - Microsoft Fabric Community
Solved: How to automatically transfer data from a semantic... - Microsoft Fabric Community
Azure Data Factory (ADF):
Solved: Extract data from semantic models using ADF or sim... - Microsoft Fabric Community
Best Regards
You can access a data warehouse via its SQL Endpoint (for example). You can run custom SQL in your Power Query code.