Forum Discussion
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
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,
3 Replies
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-adminI hope that helps,
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-groupTechnically $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,
