topic Problem viewing reports in Power BI Report Server in Report Server

Problem viewing reports in Power BI Report Server

Nanoputush — Thu, 13 Aug 2020 04:03:06 GMT

We have published some reports on Power BI Report Server, which had been working fine but stopped working overnight. These dashboards connect to a SQL Server 2016 SP1-CU6 database. The strange thing is that the error occurs only in Report Server, since the same report consulted from Power BI Desktop or Power BI Service works correctly. I also see that there are reports in Report Server connected to Analysis Services that do work well, that is, the problem seems to be focused on those that use a SQL Server database as source. We already tested credentials and yes they are fine, in fact it does make the connection when testing it.

Re: Problem viewing reports in Power BI Report Server

amitchandak — Thu, 13 Aug 2020 06:06:16 GMT

Nanoputush , You can log an issue -https://community.powerbi.com/t5/Issues/idb-p/Issues

or support ticket : https://powerbi.microsoft.com/en-us/support/

Re: Problem viewing reports in Power BI Report Server

KBO — Fri, 14 Aug 2020 08:04:24 GMT

Hi Nanoputush ,

check the credetials behind the dataset on the Report Server. May be the Password expires because you used a non-technical user?

Best,

Kathrin