Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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! 🙂
Solved! Go to 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
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!
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.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.