Export all source files

[Anonymous]

Good day. Is there a way to extract all source files from a powerBI project without manually clicking into each table?  I have 6 projects wth approx 30 tables each, it will take me a lifetime to do it manually. Many thanks in advance

[smpa01]

@Anonymous  what do you exactly mean by - Is there a way to extract all source files from a powerBI project

Do you want to extract all the source data/source query?

[Anonymous]

I'm trying to extract all source tables/source data

[smpa01]

@bcdobbs @GilbertQ does DMV have anything that gives the data for all 30 tables at once? I doubt it, but need your expertise here.

@Anonymous  my two cents - alternatively, you can create a power query and run a ssas query with following DMV query that will generate all the source code query at once and then you can run each of them seperately to get to the data.

[bcdobbs]

I can't think of anything in DMV that would help apart from what you've given.

Did wonder if you could dynamically run each returned row from the query you give and throw the whole lot into JSON but not really sure what is gained.

[bcdobbs]

Struggling to picture how this would look / what you need as an output @Anonymous 

You have a number of projects each with a number of tables. Do you want the data that power bi has loaded in it's model or the raw source data from underlying sources before it goes through power query transformation.

Either way do you then want to end up with a spreadsheet with a tab per source?

[Anonymous]

I can't make this any clearer than I have unfortunately.

So I have a bunch of powerbi projects from a third party. They will not provide the raw data files, so I have to extract each individual table from each project.  Ie go into each table view; right click; copy table and then paste into excel. It's a long and tedious process and each of the 6 projects has approx 30 tables.

I'm looking for a way to make this process a bit easier

[bcdobbs]

Ok think I'm understanding!

@amitchandak is right I'd install DAX studio. Once in there for each table execute:

EVALUATE TableName

Will return all data and you should have an option to save to csv.

I'm sure you can write a script to automate at least some of that. Will have a look and send some step by step instructions if i come up with anything.

[bcdobbs · Accepted solution]

I think this is what you need:

https://m.youtube.com/watch?v=-Gfgnk6R0Qw

[Anonymous]

Thanks for the input. I'm new to PowerBI so, I have no clue how this would work. I'll give it a go though

[amitchandak]

@Anonymous , check if DAX studio can help you

[Anonymous]

Thanks Amit, but I literally have no idea how to access DAX studio tbh 😫