Am I able to access the SQL query and DAX specification via C# .net library

[AntonUQ]

I have a large client who is trying to stringently manage what data is being used in a dashboard and then control the changes to this data (i.e. changes to the SQLs).

I therefore need to programatically extract the source queries and also the DAX computations used, from the powerBI file (.pbix file). so that it can be saved within source control and audited etc.

Is this possible?  Can I use a c# library to do this within .net?

Many thanks.

[v-lionel-msft]

Hi @AntonUQ ,

Maybe you can try to use a packet capture tool to capture the query sent from the Service to the data source.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.