Forum Discussion
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 it manually. Many thanks in advance
I think this is what you need:
11 Replies
- amitchandakSuper User
Anonymous , check if DAX studio can help you
- AnonymousNot applicable
Thanks Amit, but I literally have no idea how to access DAX studio tbh 😫
- smpa01Community Champion
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?
- AnonymousNot applicable
I'm trying to extract all source tables/source data
- smpa01Community Champion
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.