Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Export all source files

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 i...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
bcdobbs
Community Champion
4 years ago

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.