Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power BI Push Dataset API GetTablesInGroup: Able to query the columns but not the measures

I have created a Push Dataset and would like to see the measures and definitions of the measures. It seems as though I should be able to do this with the GetTablesInGroup call specified here:
https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-get-tables-in-group#measure

 

I am able to query the columns using this method and url

https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/tables/{table_name}/columns
 
But when I try to get either all of the tables contents or the measures specifically
https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/tables/{table_name}
https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/tables/{table_name}/measures
 
I get a 404 error.
 
Should I be able to query the measures?
Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

     

    I have created a Push Dataset and would like to see the measures and definitions of the measures

     

    As far as I know Push datasets (or hybrid streaming datasets) do not support measures.  In addition, measures are not really tied to tables (ignoring the "home table"  construct for  a minute)

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks for the reply Ibendlin. I can definitely see that the measures within the Push Dataset are working, I've been able to build reports/visuals off of this Push Dataset and utilise them.

       

      I didn't realise that measures aren't tied to tables. I might look into if you can access the measures directly through the dataset. 

       

      It does make the doco seem a bit odd though as it certainly looks like I should be able to use the table definitions, which include measures.

       

      Thanks again. I'll keep looking into it. 

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        I was never able to add measures to my hybrid streaming datasets. You are saying there are no issues with Push datasets? How much history are you usually seeing?