powershell - Getting Power BI Measures and Columns via REST API

Question

I intend to get list Power BI Measures and Columns from a Power BI dashboard published in Power BI workspace. Is it possible to get this via Power BI REST API or PowerShell?

What I have tried so far:

1. Downloaded the PBIX and saved the same as a template file
2. I then programmatically got the measures and columns from the template file(saved as zip)

Is there a simple approach for this? I am aware of DAX studio but I am looking for a solution or an approach that can directly connect to workspace and get the details.

question from:https://stackoverflow.com/questions/65932916/getting-power-bi-measures-and-columns-via-rest-api

Answer 1

The Power BI API returns admin info on the state of a dataset, but not the data structure.

If the dataset is compatible and the XMLA endpoint for the workspace is open, you can connect to that and use it like you would an Analysis Services database, including getting the measures and columns. You can use any tool or custom code that implements the MSOLAP or AMODB libraries. DAX Studio is just one of these options. The url of a workspace will be powerbi://api.powerbi.com/v1.0/[tenant name]/[workspace name]