How to fetch multiple PBI dashboard mqueries and native queries via code for governance purpose

[Ani_SC]

We are using PBIRS , for governance purpose we need a way to fetch mquery and native query via code ( any other ways possible) for governance of dashboards.

Checking each query from corresponding pbix files for 200+ dasboards is tedious .

Any help is appreciated.

[Gengar]

Hi @Ani_SC 

Please check if this could help:

https://powerbi.microsoft.com/es-es/blog/sharing-and-discovering-queries-using-power-query-and-power...

[Ani_SC]

Thanks for your reply though this does not seem to help retrieve all powerqueries from multiple PBI dashboards.

 A dashboard can have multiple power queries and it will be tedious to share each of the power queries individually.