Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
kyledametto
Frequent Visitor

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#measu...

 

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?
3 REPLIES 3
lbendlin
Super User
Super User

 

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)

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. 

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?

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors