Forum Discussion

AntonUQ's avatar
AntonUQ
New Member
5 years ago

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

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.

Need Help
Tips and Tricks

1 Reply

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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.