Retrieve Measures Using REST API

[Brilliant]

Hi everyone!

I wanted to get all of the measures using the PowerBI REST API.
I couldn't retrieve measures. I have only retrieved the datasets and data sources.
But datasources have poor information and even I can't get modified date or created date from the provided PowerBI REST API.

"https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdatasets"

Could you help me with this?
Also, I want to know if there is any other REST API for PowerBI Service

Thanks for your help! 🙂

[v-diye-msft]

Hi @Brilliant 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!

[Jayendran]

Hi @Brilliant ,

You can Push Datasets - Datasets GetTables which can gives you the column,measures etc., 

https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_gettables

However this API can able work only with Push DataSet, If you developed your report from powerbi desktop then this API will not work.

[Brilliant]

Thanks for your kind reply

Is there any method for getting metadata without using Push Datasets?

So that I can get measures from the Datasets which are not created using Push Datasets...

I hope you have a solid solution for that.

Thanks

[v-diye-msft · Accepted solution]

Hi @Brilliant 

if you'd like retrieve all measures from one pbix file, you might try below methods:

You can run a DMV query against the Tabular cube.

Essentially you need to connect to your Power BI Desktop instance from a tool such AS Sql Server Management Studio (or MDX Studio) and issue the following Query

SELECT [CATALOG_NAME] as [DATABASE],
CUBE_NAME AS [CUBE],[MEASUREGROUP_NAME] AS [FOLDER],[MEASURE_CAPTION] AS [MEASURE],
[MEASURE_IS_VISIBLE]
FROM $SYSTEM.MDSCHEMA_MEASURES

This will output information on your measures