Forum Discussion
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. Instead, all I'm able to see is the Source from the Dataflow itself, which only the owner of the Dataflow can go to view and edit.
Is it possible to get the underlying queries and transformations viewable, either on the web app or the desktop version, and distribute that to a wider audience?
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.
1 Reply
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.