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