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
3PI-03's avatar
3PI-03
Icon for Advocate I rankAdvocate I
5 years ago

This was occurring to any previously pre enhanced metadata report with sql server database connections.

 

The following appears to have resolved my issue, atleast with sql server connections for reports created pre october report server release.

 

Steps

  1. save report with enhanced metadata option on
  2. scheduled refresh no longer works.
  3. go back to report, select file>options and settings>data source settings
  4. highlight the data source connection (only sql server in my case) and click change source.
  5. dont change anything, click ok, close, apply changes and finally save report.
  6. now when i refresh using the schedule refresh option it works with no issues.

Not sure if this works for other data sources, but it worked for me with my sql server connections. Can only assume the data source connections need to be resaved to adhere to the new metadata format?

 

Anyway, i hope this works for others.

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

this is what fixed it for us, thanks heaps 🙂

i had raised a call with MS regarding the issue and this was the response

 

--

  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 app data folder:

 

C:\Users\<user>\AppData\Local\Microsoft\Power BI Desktop SSRS\TempSaves\Backups

 

  1. Open PBI Desktop and turn off the Enhanced Metadata option. Go to File -> Options and settings -> Options -> Global-Preview features -> then uncheck the option:

 

 

 

 

  1. Restart Power BI Desktop
  2. Reopen the backup PBIX file
  3. You should be able to use backup version of the report in PBI Desktop and publish it to the PBIRS server. It is the v1 model schema and the same format as in May 2020 PBIRS.