Solved: Power BI API not returning reports list - MS SQL S...

Anonymous · ‎11-08-2021

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

Anonymous · ‎11-10-2021

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

View solution in original post

Juerg · ‎11-23-2021

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

Service Request 2111080050001434

Anonymous · ‎11-10-2021

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