Forum Discussion
Possible to programmatically read the connection information in a PBIX file
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
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
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