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 it manually. Many thanks in advance

11 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks Amit, but I literally have no idea how to access DAX studio tbh ğŸ˜«

  • smpa01's avatar
    smpa01
    Community 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?

    • Anonymous's avatar
      Anonymous
      Not applicable

      I'm trying to extract all source tables/source data

      • smpa01's avatar
        smpa01
        Community 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.