Forum Discussion

Petebro's avatar
Petebro
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Power BI Report Server October 2020 update has been released.

Hello,   I am pleased to announce we have released an update to the Power BI Report Server (October 2020) with several fixes to problems commonly reported here on the Power BI Community Forums.  Th...
PBI Desktop on-prem
PBIRS Oct 2020
Report Server
jimv2000's avatar
jimv2000
Frequent Visitor
5 years ago

Petebro Anonymous 

I installed the 11/18 update this morning. The version shows 1.9.7627.11028 and the server has been rebooted. Dashboards with failing scheduled refreshes have not started working again.

For a test, I created a simple dashboard with the Enhanced Metadata option disabled. It runs "SELECT TOP 100 * FROM ReportServer.dbo.DataSource" (a database and table that everyone here should have) and displays a few fields in a table visual. I published that to PBIRS and scheduled refresh worked fine. I then enabled the Enhanced Metadata option, restarted PowerBI Desktop, then re-opened my test dashboard, saved it, and tried the scheduled refresh again. It failed immediately with the "The credentials provided for the SQL source are invalid" error, despite the credentials being valid when I click the test button.

I also tried creating a new, blank dashboard with Enhanced Metadata enabled, put the same query and visual, and it also failed to refresh.