Forum Discussion
Export all source files
I think this is what you need:
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?
I'm trying to extract all source tables/source data
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.
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
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?
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
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.