Forum Discussion

Anonymous

Not applicable

1 year ago

Solved

Automated extract from datawarehouse - possible?

Hi I'm new-ish to powerbi so please excuse if this is a basic question. We have an existing data warehouse. In powerbi when we query the data warehouse, we curently manually create a table ...

Anonymous
1 year ago
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

Super User

1 year ago

Can you be a bit more clear with your ask?
Is your final aspect to generate a CSV file? Then you can use data pipelines to directly create a file from fabric warehouse itself. no need of having a Power BI report created just for that purpose.