6 thoughts on “Get List of Queries in Power BI

    • Hi Andrey
      Yes, #shared is an environment variable let’s say, and it is not like other variables to work as an auto refresh in the website. The main usage of that is in Power Query on your machine.

  • I am not sure why my table is empty after clicking “Close & Apply”. The headers are there, but there is nothing.

    • Hi Alex
      This method only works inside the Power Query Editor. the environments of #shared and #sessions are not available when you load data into Power BI.
      Cheers
      Reza

      • Oh Reza, that’s such a shame! I’ve been thinking what’s wrong with my code for days. Can you please share if there are ways that I could dynamically append my queries into a table that is available when I load the data into Power BI?

        • Hi Alex
          Unfortunately, there is no way to append query names like that when you load data into Power BI unless you statically have their names somewhere.
          You can, however, append your queries data into one if you want with a simple append transformation.
          Cheers
          Reza

Leave a Reply