REST API to get reports, report filters (with all metadata) from workspace

[Mykhailo]

Hi!

I would like to get next information via REST API:

1. List of reports from workspace: name, description, url etc

2 Report filters (including slicers): name, description, possible values (if defined) 

A possible option that I found:

1 Embed report

2 Get metadata via JS SDK: Get pages and visuals in a Power BI embedded analytics application | Microsoft Docs

This solution seems to be quite complex to implement and seems like I still can't get all required data.

My usecase is: allow user to build queries as a text in a Bot and receive report url as a response (similar to Use Power BI Q&A to explore and create visuals - Power BI | Microsoft Docs).

Does anybody have more information about this topic?

Thank you

[terezaa]

Hello, I am currently facing similar problem. Did you find a way to get the metadata via rest api?

[Anonymous]

HI @Mykhailo 

You can through the REST API below to get the informations you want from specific workspace .

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports 

More info can refer to the link below .

https://docs.microsoft.com/en-us/rest/api/power-bi/reports/get-reports-in-group 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mykhailo]

Hi!

Thanks for your response.

But this API provides reports list, but not report's metadata (including list of filters).