how to retrieve the list of all my PP environments created from Power BI ?

[Anonymous]

hi 

i would like to develop a dashboard with all my created PP environments...  when i use the Dataverse connectors, I can see them, but i want to retrieve them dynamically. could you please let me know how to do this? 

thanks

[Anonymous · Accepted solution]

Hi sorry i dont know DAX... by the Dataverse connector is it possible? thanks

[Anonymous]

thanks very much

[Anonymous]

Hi sorry i dont know DAX... by the Dataverse connector is it possible? thanks

[Anonymous · Accepted solution]

Hi sorry i dont know DAX... by the Dataverse connector is it possible? thanks

[Greg_Deckler · Accepted solution]

@Anonymous That's not DAX. That is Power Query code. Go into Power Query Editor (Transform Data). Create a new blank query. Click on Advanced Editor. Select all the text and delete it. Paste in the code I provided. Press OK.

[Greg_Deckler]

@Anonymous Use this:

let
  Source = CommonDataService.Database()
in
  Source