cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Petebro
Microsoft
Microsoft

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.  The release can be found here:

https://www.microsoft.com/en-us/download/details.aspx?id=57270

 

Changelog will be updated tomorrow with the following information: 

 

Version: 1.9.7627.11028 (Build 15.0.1104.264), Released: November 18, 2020
        - Bug fixes
            - Fixed issue preventing users from changing fields in site settings via the portal.
            - Fixed issue with refresh of Power BI Reports when using 'EnterData' data source.
            - Fixed issue with refresh of some models using enhanced dataset metadata.
            - Fixed issue where some Power BI reports could not be published to the Report Server from Power BI Desktop
 
Thanks for being active part of the Power BI community and please let us know if you run into any problems.
 
-Pete
97 REPLIES 97
tjcps
Regular Visitor

According to the link you sent, my sources are upgradable. And before installing this new version of Power BI, it already worked correctly. After the update the problem appeared.

Petebro
Microsoft
Microsoft

Some rapid fire followup questions:

  1. Are you having issues with all reports or just this one?
  2. Can you say the types of datasources found within this report?
  3. Anything different/unique as it related to datasources connectivity in it?
  4. I assume the refresh fails consistently as well?
  5. Just double checking you are on Version: 1.9.7627.11028 (Build 15.0.1104.264). You can find this version in the portal under the about dialog.

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.

 

 

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:

 

braddo81_0-1607542792676.jpeg

 

 

 

  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.
ezzkht
Regular Visitor

This workaround worked for me 👍 Thanks a lot 😃

tjcps
Regular Visitor

Same problem here. My pbix files has Web Content Data Source and SQL Server data sources. The PBIXs files that has only SQL Server data sources works fine. But the others who has Web Content fails. 

tjcps
Regular Visitor

In the Portal, the this is the message: 

...
[0] -1056505856: COM error: System.Core, A sequência não contém elementos.
[1] -1055129594: The current operation was cancelled because another operation in the transaction failed.
[2] -1055784828: The database operation was cancelled because of an earlier failure.
[3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

In the log of the SSRS:


2020-11-19 11:30:06.0997|ERROR|69|Error Processing Data Model Refresh: ...

Status: Error Failed Data Refresh, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'COM error: System.Core.
'.
em Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.ExecuteActionWithLogging(Action methodToExecute, String description, String localizedDescription, String messageInFailure, RefreshInfo refreshInfo, DataAccessors dataAccessors, ReportEventType operation, Boolean isDataRetrieval, Boolean showInExecutionLog, Boolean sendToTelemetry)
em Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshData(RefreshInfo refreshInfo)
em Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass34_0.<ExecuteActionWithLogging>b__0()
em Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__33`1.MoveNext()

3PI-03
Advocate I
Advocate I

upgraded to latest version. scheduled refresh still not working. report refreshing ok until saving report with enhanced metadata turned on.

 

Scheduled refresh breaks when scheduling:

 

SessionID: 65497027-7267-4f16-8ef4-2fb3206e3e0a
[0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
[1] -1055784828: The database operation was cancelled because of an earlier failure.

 

credentials are tested and correct.

Petebro
Microsoft
Microsoft

Can you try to download the file from this page again and show me the version show in the windows right click -> properties ui? https://www.microsoft.com/en-us/download/details.aspx?id=57270

 

My guess is the page is still sending the old version (15.0.1104.239) not (15.0.1104.264) EXE. This is a temporary problem as I made this post right as we published the file and it takes some time to propogate and send the new file. Sorry for this confusion, but "Upgrade Edition" is meant to change the SKU of the product installed not go from Version A -> Version B.

Compared version first release and the latest, show as below


image.png

Does this means they are the same version?

Yes the CDN is still sending you the previous version.  This should resolve on it's on in the next few hours. You should see '1.9.7627.11028'

Dearc
Helper I
Helper I

I' m running version 15.0.1104.239

 

image.png


And downloaded the latest release

image.png
But still seeing this

 image.png


Choose the “Developer” version, unable to go to next step.

 

image.png

 

 

Petebro
Microsoft
Microsoft

Hmm upgrade is the option you want. However, I suspect you somehow were served the old version of the .exe from the CDN as you should only see one option when upgrading. If you see three options in the UI then you are running the same version of the installer that is already installed (this allows you to Upgrade Edition, Repair and Uninstall). Please double check the version of the installer is Version: 1.9.7627.11028 (Build 15.0.1104.264). If the version is not this one please try the above url again as it takes some amount of time to propogate to all download.microsoft.com CDNs around the world.


When upgrading you should see this screen:

upgrade.PNG

 

Not this one:

upgrade2.PNG

 

If you have the correct version and are seeing the single upgrade option. Are you able to reboot your machine and launch the new PowerBIReportServer.exe again?


Alternatively you can try the command line install by running the following:

PowerBIReportServer.exe /quiet /noreboot 

Dearc
Helper I
Helper I

Shoud I "Repair" or "Upgarde" since I already installed Oct 2020 before ? 
When I choose "Upgrade" I'm unable to go to next step.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.