topic Re: Power BI API not returning reports list - MS SQL Server Analysis Service in Developer

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

Anonymous — Mon, 08 Nov 2021 11:06:03 GMT

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

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

Anonymous — Thu, 11 Nov 2021 01:14:50 GMT

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

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

Juerg — Tue, 23 Nov 2021 11:04:18 GMT

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

Service Request 2111080050001434