Power BI API not returning reports list - MS SQL Server Analysis Service

[Anonymous]

Hello,

I'm trying to use Power BI REST API in order to fetch my reports from my workspaces.

All my workspaces have reports that are using MS SQL Server Analysis Service as a data source.

When I try to use the Power BI REST API (get reports endpoint), the response is successful but the array "value" of report objects comes empty, for every workspace.

Can someone advise what could maybe be wrong? Is there any setting that must be enabled for this to work?

Regards,

Manuel Sambade

[Juerg]

Microsoft has identified the bug and it will be fixed with a deployment on the first weekend of December 2021.

Service Request 2111080050001434

[Anonymous · Accepted solution]

Hi @Anonymous,

Are you test with pagination reports? As the document said, if your report does not include corresponding datasets in the power bi service, the API may not show the corresponding information in the response.

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.

Regards,
Xiaoxin Sheng