Possible to programmatically read the connection information in a PBIX file

[NickKCI]

Hi,

I'm curious if there is any way to programmatically read the connection information for that data source that a PBIX file points to? 

I know I can rename the PBIX file to a ZIP file and look at the connection information that way but I was hoping there was a different mechanism that would allow me to do that.

Thanks

Nick

[NickKCI]

Hi Hari,

Thanks for the suggestion.  I published the PBIX file to Power BI, but because the data source for this PBIX file is a live connection to an on-prem SSAS server I'm not able to see the data in Power BI.  And I'm also not able to see the data source details.

Ideally what I would need is some way to read this information from the PBIX file or from the local SSAS server that is running with Power BI for this file.

Thanks

Nick

[Hariharan_R · Accepted solution]

Hi @NickKCI,

If your report is published to premium workspace then you can leverage the XMLA endpoint capability. You can connect the dataset in DAX studio and you can query the data or you can use the DMVs in DAX studio to read the metadata information.

https://daxstudio.org/tutorials/getting-connected/

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[Hariharan_R]

Hi,

You can publish to Power BI service and use below REST api to get the data source details used on the dataset (PBIX) file.

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/get-datasources-in-group

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin