topic Re: Power BI On-Premise Report Server Upgrade Broken version link in Report Server

Power BI On-Premise Report Server Upgrade Broken version link

khalidsk — Sun, 05 Nov 2017 10:56:03 GMT

Hi,

There is a version chain broken between Power BI Report server on-premise version.

We are currently using Power BI report server on-premise Aug 2017 Preview version. The latest upgrade available as per below link is directly related to June 2017 GA version.

https://powerbi.microsoft.com/en-us/documentation/reportserver-release-notes/

We are specifically looking for Sharepoint List Schedule Refresh or Live/DirectQuery. This feature is currently not available in August 2017 preview but it is mentioned as supported in the latest update Oct 2017.

Why is August 2017 preview not included in Upgrade plan?

What would be the steps to move to Oct 2017 version from Aug 2017?

Are there any features missing in this version that are already available in August 2017 preview?

Directly running upgrade is not helping as the reports manager portal is going offline [HTTP 503 error is seen]. I had to uninstall and reinstall Report Server from scratch to have it restored.

Any clarifications provided are greatly helpful.

Regards,

Khalid

Re: Power BI On-Premise Report Server Upgrade Broken version link

mgmeyer — Sun, 05 Nov 2017 16:20:32 GMT

Upgrade from Aug. Preview to Oct GA release is supported and should work, do you have any more infomation on the errors you were seeing? Also we there any specific errors in the logs? As far as Features the August preview was just an early preview release for the Excel and Embedded Model functionality in the server. We wanted to get early version out to get customer feedback on it. The Oct release contains the final version or GA version of those bits as well as some new funcitonality (e.g. URL Params, Scheduled Data Refersh, OData DataSets ...). The preview version was never meant to be used in a produciton environment since it was only availabe in an evaluation edition, that said upgrade should work.

Matt M.

Re: Power BI On-Premise Report Server Upgrade Broken version link

khalidsk — Mon, 06 Nov 2017 05:18:34 GMT

Hello Matt,

Thank you for the information.

We are evaluating the Power BI On-Premise Preview version in our development setup.

When I upgrade Report Server from Aug 2017 to Oct 2017 version, installer is completing the upgrade successfully but when I access RS portal, it shows me "HTTP 503. Service not available" message in browser. I tried to change name of Virtual directory as suggested in some discussions related to same problem, but that did not work for me.

Also, When I try to install the PBI Desktop of Oct 2017, it shows me message that a newer version of PBI Desktop is already installed. Installer is not allowing this when Aug 2017 is installed.

Please let me know if you want to have any other information.

Regards,

Khalid

Re: Power BI On-Premise Report Server Upgrade Broken version link

mgmeyer — Mon, 06 Nov 2017 15:39:27 GMT

Can you check the help about screen in Desktop and let me know the specific which version you have installed? Also for Report Server can you check the Logs specifically the RSPortalXXX and ReportingServicesXXX logs to see if there are any errors? One last quetion what URL are you trying to access for the Portal and do you have any of versions of SSRS installed on the machine?

Re: Power BI On-Premise Report Server Upgrade Broken version link

khalidsk — Tue, 07 Nov 2017 07:47:20 GMT

For accessing Portal I'm using http://localhost/Reports. It is configured to use port 80.

I see below messages in logs.

Log File Name: RSPowerBI_2017_11_07_11_35_02

2017-11-07 11:35:02.8562|INFO|1|File Logger created: 'C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPowerBI_${DailyDate}.log' - level Info, will roll at 32 Mb, process id 3400
2017-11-07 11:35:02.9969|INFO|1|CFG : Dumper.path = [..\LogFiles\] (env)
2017-11-07 11:35:02.9969|INFO|1|CFG : Name = [] (env)
2017-11-07 11:35:02.9969|INFO|1|CFG : Dumper.flags = [SendToWatson, AllThreads, AllMemory] (env)
2017-11-07 11:35:02.9969|INFO|1|CFG : Dumper.preventIfContains = [System.Threading.ThreadAbortException,System.OutOfMemoryException,System.ObjectDisposedException,System.IO.IOException,System.IO.FileLoadException,System.AppDomainUnloadedException,System.Net.Http.HttpRequestException,System.Net.HttpListenerException] (env)
2017-11-07 11:35:02.9969|INFO|1|Do not dump on: System.Threading.ThreadAbortException,System.OutOfMemoryException,System.ObjectDisposedException,System.IO.IOException,System.IO.FileLoadException,System.AppDomainUnloadedException,System.Net.Http.HttpRequestException,System.Net.HttpListenerException
2017-11-07 11:35:03.0125|INFO|1|Provider name
2017-11-07 11:35:03.0125|INFO|1|Container name Microsoft SQL Server Reporting Services Key Container 2010
2017-11-07 11:35:03.0125|INFO|1|CFG : rsConfigFilePath = [C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config] (env)
2017-11-07 11:35:03.0125|INFO|1|CFG : Hosting-databaseValidationStatus = [DowngradeDetected] (env)
2017-11-07 11:35:03.0125|INFO|1|CFG : Hosting-managementUrl = [http://localhost:8083/] (env)
2017-11-07 11:35:03.0125|INFO|1|CFG : Hosting-featureSwitches = [e30=] (env)
2017-11-07 11:35:03.1374|INFO|1|CFG : Hosting-portalUrl = [http://localhost/Reports] (env)
2017-11-07 11:35:03.1374|INFO|1|Setting up Hosted Process State
2017-11-07 11:35:03.1374|INFO|1|CFG : rsConfigFilePath = [C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config] (env)
2017-11-07 11:35:03.1374|INFO|1|Attempting to read Configuration from file C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2017-11-07 11:35:03.5281|INFO|1|The web server needs to run elevated
2017-11-07 11:35:03.5281|INFO|1|Web Server is running.

Log File Name: RSHostingService_2017_11_07_11_35_00

2017-11-07 11:35:00.3380|INFO|1|File Logger created: 'C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSHostingService_${DailyDate}.log' - level Info, will roll at 32 Mb, process id 4772
2017-11-07 11:35:00.3536|INFO|1|CFG : WebApiMaxWaitMS = [1000] (default)
2017-11-07 11:35:00.3536|INFO|1|CFG : WebApiBackOffExpireSeconds = [60] (default)
2017-11-07 11:35:00.3536|INFO|1|CFG : WebApiInitialWaitMS = [10] (default)
2017-11-07 11:35:00.3536|INFO|1|CFG : WebApiBackoffMultiplier = [2] (default)
2017-11-07 11:35:00.3536|INFO|1|CFG : ServiceWatchdogIntervalInSeconds = [10] (default)
2017-11-07 11:35:00.3536|INFO|1|Current Directory : C:\Program Files\Microsoft Power BI Report Server\PBIRS\RSHostingService
2017-11-07 11:35:00.5567|INFO|1|CFG : managementUrl = [http://localhost:8083] (service config file)
2017-11-07 11:35:00.5567|INFO|1|CFG : rsConfigFilePath = [..\ReportServer\rsreportserver.config] (service config file)
2017-11-07 11:35:00.5567|INFO|1|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2017-11-07 11:35:00.6661|INFO|5|Updating application config files
2017-11-07 11:35:00.6661|INFO|5|Syncing service machine key
2017-11-07 11:35:00.6817|INFO|5|CFG : managementUrl = [http://localhost:8083] (service config file)
2017-11-07 11:35:00.6817|INFO|5|CFG : rsConfigFilePath = [..\ReportServer\rsreportserver.config] (service config file)
2017-11-07 11:35:00.6817|INFO|5|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2017-11-07 11:35:00.6817|INFO|5|CFG : MaxWaitMinutes = [60] (default)
2017-11-07 11:35:00.6817|INFO|5|CFG : BackOffExpireMinutes = [60] (default)
2017-11-07 11:35:00.6817|INFO|5|CFG : InitialWaitSeconds = [30] (default)
2017-11-07 11:35:00.6817|INFO|5|CFG : BackOffMultiplier = [2] (default)
2017-11-07 11:35:00.6973|INFO|5|Launching Process : Management Service
2017-11-07 11:35:00.6973|INFO|5|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\Management\RSManagement.exe
2017-11-07 11:35:02.5281|INFO|12|Fetched ManagementState from Management state = DowngradeDetected, Encryption key present = False
2017-11-07 11:35:02.5281|INFO|12|CFG : rsConfigFilePath = [C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config] (Storing to SubProcess Environment)
2017-11-07 11:35:02.5281|INFO|12|CFG : Hosting-databaseValidationStatus = [DowngradeDetected] (Storing to SubProcess Environment)
2017-11-07 11:35:02.5281|INFO|12|CFG : Hosting-managementUrl = [http://localhost:8083/] (Storing to SubProcess Environment)
2017-11-07 11:35:02.5281|INFO|12|CFG : Hosting-portalUrl = [http://localhost/Reports] (Storing to SubProcess Environment)
2017-11-07 11:35:02.5593|INFO|12|CFG : Hosting-featureSwitches = [e30=] (Storing to SubProcess Environment)
2017-11-07 11:35:02.5593|INFO|12|Launching Process : RS Service
2017-11-07 11:35:02.5593|INFO|12|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\bin\ReportingServicesService.exe
2017-11-07 11:35:02.5593|INFO|12|Launching Process : Portal
2017-11-07 11:35:02.5593|INFO|12|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\Portal\RSPortal.exe
2017-11-07 11:35:02.5593|INFO|12|Launching Process : PowerBI
2017-11-07 11:35:02.5593|INFO|12|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\PowerBI\RSPowerBI.exe
2017-11-07 11:35:02.5593|INFO|4|Service watchdog: starting
2017-11-07 11:35:03.4031|WARN|11|Child Process [Portal] Died. Check the log for further information
2017-11-07 11:35:03.4031|INFO|11|Immediate restart of process Portal
2017-11-07 11:35:03.4031|INFO|11|Launching Process : Portal
2017-11-07 11:35:03.4031|INFO|11|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\Portal\RSPortal.exe
2017-11-07 11:35:04.2468|WARN|11|Child Process [Portal] Died. Check the log for further information
2017-11-07 11:35:33.4155|INFO|5|Throttled restart of process by 29,156.24ms: Portal
2017-11-07 11:35:33.4155|INFO|5|Launching Process : Portal
2017-11-07 11:35:33.4155|INFO|5|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\Portal\RSPortal.exe
2017-11-07 11:35:34.1030|WARN|12|Child Process [Portal] Died. Check the log for further information
2017-11-07 11:36:31.4588|INFO|10|Killing Process: Management Service
2017-11-07 11:36:31.4588|INFO|10|Killing Process: RS Service
2017-11-07 11:36:31.4588|INFO|10|Killing Process: PowerBI

Version Shown when opening Power bi desktop is "2.49.4831.801 64-bit (August 2017)".

Regards,

Khalid

Re: Power BI On-Premise Report Server Upgrade Broken version link

khalidsk — Tue, 07 Nov 2017 11:28:12 GMT

Matt,

Please ignore the issue. Thanks for helping.

I downloaded the October 2017 exe files which was published on Nov 1, 2017 and everything is working fine now. We are going to check Scheduled Data Refresh for Sharepoint List (On-Premise Setup). Will post results ASAP.

Edit:

Scheduled Refresh is working fine. Only one issue remained after upgrade. Which is all the data sources respective to report got reset. Now we need to manually open each report in Power bi Desktop, save and close it to work in report server.

Currently I do not see an option in Power BI Desktop to configure with data source from Report Server. Is there a way to use Data Sources same like we do in SSRS reports?