Forum Discussion
Helper IVScheduled Refresh Failing in October 2020
Hi Lorenz33 ,
This is a known issue that has been submitted internally (ICM#: 216889995). Engineers are working on a fix. If there is any new message, I'll update it in this thread. Thanks for your understanding.
In addition, one workaround for reference:
1. Before the PBIX file is upgraded to the new format in the October 2020 version of PBI Desktop (Optimized for PBIRS), a backup copy is saved in the AppData folder:
C:\Users\<user>\AppData\Local\Microsoft\Power BI Desktop SSRS\TempSaves\Backups
2. Open PBI Desktop and turn off the Enhanced Metadata option. Go to File -> Options and settings -> Options -> Global-Preview features -> then uncheck the option:
3. Restart Power BI Desktop
4. Reopen the backup PBIX file
5. You should be able to use this version of the report and publish it to the PBIRS server. It is the v1 model and the same format as in May 2020 PBIRS.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IWe are having a similar issue after our servers were patched on 1/17.
A high % of our refreshes hitting Oracled DBs are failing - though not all of them.
Do you happen to have a list of KBs that were applied against your PBIRS host? I wonder if there's something breaking PBIRS
Helper IVThe following KBs were applied:
MS20-12-SO8-4592497
Security-only update
This security update includes quality improvements. Key changes include:
Addresses a security vulnerability by preventing applications that run as a SYSTEM account from printing to "FILE:" ports. To address this issue in the future, make sure your applications or services run as a specific user or service account.
Security updates to Windows Graphics, Windows Peripherals, and Windows Core Networking.
MS20-12-SO81-4592495
Security-only update
This security update includes quality improvements. Key changes include:
Addresses a security vulnerability by preventing applications that run as a SYSTEM account from printing to "FILE:" ports. To address this issue in the future, make sure your applications or services run as a specific user or service account.
MS20-12-SSU-4592510/4593175
Servicing stack update for Windows Server
This update makes quality improvements to the servicing stack, which is the component that installs Windows updates. Servicing stack updates (SSU) makes sure that you have a robust and reliable servicing stack so that your devices can receive and install Microsoft updates.
We are going to schedule a restart of the Power BI Reporting Server service to see if this helps. The problem is only happening on one report. On the same server the scheduled refreshes are still working for reports with 1 or 2 SharePoint data sources.