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

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.

Reply
ibm-dev
Regular Visitor

IS $filter URL parameter only supported for Groups and Admin API ?

IS $filter URL parameter only supported for Groups and Admin API ?
Groups : https://learn.microsoft.com/en-us/rest/api/power-bi/groups
Admin:  https://learn.microsoft.com/en-us/rest/api/power-bi/admin

Is this parameter supported for any other API e.g dataset, scorecard etc ? or is there any way i can filter using the API ?
e.g i want to filter dataset and scorecard with name  ?$filter=name eq 'tesdata' 

 

Thanks

1 ACCEPTED SOLUTION

Hi. We don't know Microsoft reasons for not adding a filter to a request of their Rest API. I guess because Admin API is more massive and a filter might become handy. The get datasets from datasets category will only show the datasets the user logged is added to a workspace. The admin can bring them all.

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

3 REPLIES 3
ibm-dev
Regular Visitor

thank for the reply @ibarrau 
So that means only admin API has $filter support for e.g GET Dataset API and non admin API don't have $filter for the same  GET Dataset API
Admin Dataset GET API (with $filter)https://learn.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-datasets-in-group-as-admin 
Non-Admin GET API (without $filter) - https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-datasets-in-group

 

 Technically $filter could have been also supported for non-admin API any specific reason it is not supported for non-Admin ?

Hi. We don't know Microsoft reasons for not adding a filter to a request of their Rest API. I guess because Admin API is more massive and a filter might become handy. The get datasets from datasets category will only show the datasets the user logged is added to a workspace. The admin can bring them all.

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

ibarrau
Super User
Super User

Hi. Each parameter or body at the Rest API depends on the specific request. That specific parameter it's more frequent an Admin one because Admin API is more massive bringing requests against all tenant. The other requests might ask for things that will bring less results.

If you want to filter datasets you can use the Get Datasets from the Admin API
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-datasets-in-group-as-admin

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors