Forum Discussion

Brilliant's avatar
Brilliant
Regular Visitor
6 years ago
Solved

Retrieve Measures Using REST API

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! 🙂

Dataflow
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    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

4 Replies

    • Brilliant's avatar
      Brilliant
      Regular Visitor
      6 years ago

      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's avatar
        v-diye-msft
        Community Support
        6 years ago

        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

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    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!