URL filtering for Power BI Rest API

[prathyoo]

Hi,

I am trying to use the 'Get Reports in Group' API and am struggling with the $filter parameter. The $filter parameter seems to accept name and datasetId for filtering but I would like to filter on the reportType as well. Is there any documentation on which fields in the output json are filterable.

https://api.powerbi.com/v1.0/myorg/groups/4927xxxxxxxxxxxxxxx18a593f/reports?%24filter=datasetId%20e...

I was trying the above api call and get a 400 response code. If I remove the reportType filter, the api responds back with the json output listing all the reports in the workspace associated to the datasetId in the filter.

[lbendlin]

Do you want to distinguish between PowerBIReport and PaginatedReport ?

It might be simpler (and faster) to pull the entire API response down and filter it later. 

[prathyoo]

Yes. The idea is to use power automate to export the rdl files as well as pbix files associated to a particular dataset to store it in sharepoint. But, I couldn't find documentation on which fields can be used in the filter parameter of the api url. So far my test indicates that the name and datasetId fields could be used to filter the output of the api call. 

[lbendlin]

I don't think these filters actually do anything.  At least in my tests they had no effect.

This might trip you up as well: 

Note: Paginated reports (rdl) don’t have a dataset. As a result, in the API response for paginated reports, the dataset ID value isn’t displayed.