topic Re: Power BI Report Server October 2020 update has been released. in Report Server

Power BI Report Server October 2020 update has been released.

Petebro — Thu, 19 Nov 2020 01:19:23 GMT

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

Re: Power BI Report Server October 2020 update has been released.

Dearc — Thu, 19 Nov 2020 01:54:20 GMT

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

Re: Power BI Report Server October 2020 update has been released.

Petebro — Thu, 19 Nov 2020 02:26:50 GMT

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:

Not this one:

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

Re: Power BI Report Server October 2020 update has been released.

Dearc — Thu, 19 Nov 2020 02:55:31 GMT

I' m running version 15.0.1104.239

And downloaded the latest release

But still seeing this

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

Re: Power BI Report Server October 2020 update has been released.

Petebro — Thu, 19 Nov 2020 03:28:29 GMT

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.

Re: Power BI Report Server October 2020 update has been released.

Dearc — Thu, 19 Nov 2020 03:42:01 GMT

Compared version first release and the latest, show as below

Does this means they are the same version?

Re: Power BI Report Server October 2020 update has been released.

Petebro — Thu, 19 Nov 2020 03:47:21 GMT

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'

Re: Power BI Report Server October 2020 update has been released.

3PI-03 — Thu, 19 Nov 2020 13:30:33 GMT

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.

Re: Power BI Report Server October 2020 update has been released.

Petebro — Thu, 19 Nov 2020 17:37:46 GMT

Some rapid fire followup questions:

Are you having issues with all reports or just this one?
Can you say the types of datasources found within this report?
Anything different/unique as it related to datasources connectivity in it?
I assume the refresh fails consistently as well?
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.

Re: Power BI Report Server October 2020 update has been released.

tjcps — Thu, 19 Nov 2020 17:23:40 GMT

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.

Re: Power BI Report Server October 2020 update has been released.

tjcps — Thu, 19 Nov 2020 17:30:24 GMT

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()

Re: Power BI Report Server October 2020 update has been released.

Petebro — Thu, 19 Nov 2020 17:57:44 GMT

Ah that may be because of a limitation listed here. I've filed a bug for a future release to return a better error message for this error in refresh.

https://docs.microsoft.com/en-us/power-bi/report-server/data-sources

Power BI Report Server has a limitation when using web data: only data files from web can be refreshed. Data based on Page or By example aren't refreshable. This limitation is because the M expressions created with Web.BrowserContents and Web.Page can't be refreshed. Power BI Report Server can only refresh Web.Contents data sources.

Re: Power BI Report Server October 2020 update has been released.

Anonymous — Thu, 19 Nov 2020 18:14:56 GMT

The Scaled Out and the Power BI Cloud tabs are missing in the Report Configuration Manager

Re: Power BI Report Server October 2020 update has been released.

Petebro — Thu, 19 Nov 2020 18:24:43 GMT

@Anonymous Can you provide a screenshot? After you connect to the PBIRS instance the options should show up per usual.

Re: Power BI Report Server October 2020 update has been released.

Anonymous — Thu, 19 Nov 2020 18:33:46 GMT

ok, that is just too weird. Now they are there. This morning, they were not.

Re: Power BI Report Server October 2020 update has been released.

Petebro — Thu, 19 Nov 2020 18:38:55 GMT

Before you connect to PBIRS they will be hidden, but show up when you connect to the instance. Perhaps this is what you saw.

Re: Power BI Report Server October 2020 update has been released.

Anonymous — Thu, 19 Nov 2020 18:40:57 GMT

Yep, that is it.

Re: Power BI Report Server October 2020 update has been released.

Anonymous — Thu, 19 Nov 2020 19:19:00 GMT

its gone again and I just found it and connected

Re: Power BI Report Server October 2020 update has been released.

tjcps — Thu, 19 Nov 2020 19:56:23 GMT

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.

Re: Power BI Report Server October 2020 update has been released.

Petebro — Thu, 19 Nov 2020 20:07:24 GMT

Are you having issues with all reports or just this one?
Can you say the types of datasources found within this report?
Anything different/unique as it related to datasources connectivity in it?
I assume the refresh fails consistently as well even after the restart of the server?