Forum Discussion

Anonymous's avatar
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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

lbendlin's avatar
lbendlin
Super User
1 year ago

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