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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
sreenivasulub
New Member

Change to Power Bi REST API out put

In SKT we are currently consuming a lot of data from the API to manage our workspaces, users, usage stats and such. A couple of days ago our the Rest API apparently changed. We could normally filter in capacity, allowing us to single out SKT workspaces and users, This option has now disappeared, now giving us usage data for all of company, and having no options for filtering back to only our own workspaces. Can anything be done to revert this change?

1 REPLY 1
MohdZaid_
Resolver II
Resolver II

Hey @sreenivasulub  ,

 

If the Power BI REST API recently stopped allowing you to filter by capacity in the request itself, this change cannot be reverted from your side. Microsoft periodically updates and standardizes the Admin REST APIs, and when parameters are deprecated or removed, tenants must adapt to the new supported behavior. There is no setting in the tenant or capacity configuration that allows you to restore the previous filtering option.

 

The correct approach now is to retrieve the full dataset from the Admin endpoint and apply filtering in your own solution layer. For example, first call the capacities endpoint to retrieve the list of capacity IDs that belong to SKT:

 

GET https://api.powerbi.com/v1.0/myorg/admin/capacities

Then retrieve all workspaces including their capacity information:

GET https://api.powerbi.com/v1.0/myorg/admin/groups?$expand=capacity

From there, filter the workspaces locally by keeping only those where the workspace capacityId matches one of your SKT capacity IDs. If you are consuming usage data through the activity events endpoint:

GET https://api.powerbi.com/v1.0/myorg/admin/activityevents?startDateTime=2026-02-24T00:00:00&endDateTime=2026-02-24T23:59:59

 

you should join the returned WorkspaceId to your filtered workspace list and restrict the results to only the capacities relevant to SKT. This design ensures you remain compliant with the current API behavior and makes your solution more robust against future changes.

 

From an enterprise architecture perspective, it is not recommended to rely on server-side filtering in Admin APIs for tenant segmentation. Instead, maintain your own registry of approved capacity IDs or workspace IDs and apply filtering within your data pipeline or Power BI model. This approach is more stable, scalable, and future-proof.

 

If this explanation helped, please mark it as the solution so others can find it easily.

If it helped, a quick Kudos is always appreciated it highlights useful answers for the community.

Thanks for being part of the discussion!

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 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.