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.
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
Solved! Go to 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,
Happy to help!
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,
Happy to help!
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,
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |