Automated extract from datawarehouse - possible?

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

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.

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.    🙂