topic Re: Automated extract from datawarehouse - possible? in Developer

Automated extract from datawarehouse - possible?

wokka — Fri, 07 Feb 2025 06:18:26 GMT

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 and drag in 4 dimensions. Then we do a manual extract of data, out into a csv file.

My question is can we write DAX code ( or similar ) to do that extraction, and do you have to manually run the DAX inside powerbi or can we kick it off from a command line or python or a powerbi server etc?

I'm starting off by thinking about this at a high level/concept level, then will drill down into the technical, if this approach is possible.

Thanks in advance.

Re: Automated extract from datawarehouse - possible?

lbendlin — Sat, 08 Feb 2025 15:39:07 GMT

You can access a data warehouse via its SQL Endpoint (for example). You can run custom SQL in your Power Query code.

Re: Automated extract from datawarehouse - possible?

NandanHegde — Sun, 09 Feb 2025 15:08:45 GMT

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.

Re: Automated extract from datawarehouse - possible?

wokka — Sun, 09 Feb 2025 23:29:23 GMT

Hi,

Thanks everyones responses so far

So what we have is a powerbi pbix file that connects to an existing powerbi sematic model.

What I do currently is manually drag in 4 dimensions into a table to use the relationship between them to find one component of the data ( our internal Reference ID ), then extract the data out to disk in csv form using "Export data".

I guess we could do it all via TSQL code via the database backend , however all the hard work to develop the data relationships already exists in the semantic model.

Maybe this is the long way around, but its the only way that we know how to do it right now ( I'm newish to powerbi so ....) but there must be a way to avoid manual manipulation , and maybe create like a virtual table via DAX commands ( or similar ) then extract the data out from that somehow?

Thanks in advance, the fabric forum people are very helpful. 🙂

Re: Automated extract from datawarehouse - possible?

lbendlin — Mon, 10 Feb 2025 03:20:50 GMT

Correct, the best way is to run a DAX query against that semantic model with all the required columns. Then save the query results as CSV if you must

Re: Automated extract from datawarehouse - possible?

Anonymous — Mon, 10 Feb 2025 05:36:09 GMT

Hi @wokka ,

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