Forum Discussion
Export all source files
I think this is what you need:
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.
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
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.
I think this is what you need: