Forum Discussion

Doomsun's avatar
Doomsun
New Member
4 years ago
Solved

How to allow users to see underlying Query and Transformations from Dashboard

Hi,   We want to distribute our PowerBI Dashboard to the wider organization, but also want users to be able to navigate to the Query Editor and see the underlying transformations and data tables. I...
Dataflow
Need Help
  • otravers's avatar
    otravers
    4 years ago

    You can retrieve dataflow definitions in JSON format via the REST API:

    https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows/get-dataflow

     

    You could then either save these JSON objects somewhere where your team members can read them (e.g. SharePoint) or parse them to get just the queries in order to share something a bit more user friendly. If I had to do it I'd set that up via a Power Automate flow.

otravers's avatar
otravers
Icon for Community Champion rankCommunity Champion
4 years ago

You can retrieve dataflow definitions in JSON format via the REST API:

https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows/get-dataflow

 

You could then either save these JSON objects somewhere where your team members can read them (e.g. SharePoint) or parse them to get just the queries in order to share something a bit more user friendly. If I had to do it I'd set that up via a Power Automate flow.