Get Dataflow Query from the PowerBI REST API?

[Anonymous]

Hi,

I'm aware I can use the "Dataflows - Get Dataflow Data Sources" REST API to get a list of the Connection Sources for a given Dataflow however, I can't seem to find out how to return the specific query?

For instance, a Dataflow I have has a connection to our Sql server. From that API, I can see successfully in the API return:

datasourceType	connectionDetails	datasourceId	gatewayId
Sql	@{*sql server name & database*}	The datasource Id	The Gateway Id

However, I know that the dataflow is using a custom Sql statement with case statements, where clauses etc. I'd like to use the API to extract those queries across multiple dataflows to programatically perform governance checks but I can't find another API end point that provides that....

Does that functionality exist in the API or CMDlets anywhere or does anyone have any other idea how to govern how dataflows are extracting data when you have 50+ of them?

Thanks

[v-yalanwu-msft]

Hi, @Anonymous ;

Sorry I am not familiar with it, please refer to the following link.

https://community.powerbi.com/t5/Report-Server/How-to-get-M-query-from-dataflows-Power-BI-Server-Analysis/td-p/2241080

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

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.