Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
(xpost Issues)
We're practicing replacing SSRS with PBIRS. We've successfully installed and (mostly?) configured PBIRS such that it will happily run "Paginated Reports" (aka old style SSRS reports). However, we cannot save a Power BI report to PBIRS!
I'm using the June 2017 version of PBI Desktop. When I create the report - using a live AS connection, of course - and try to Save As to the PBIRS instance, I get the error message:
Saving to Power BI Report Server / An error occurred while attempting to save the report to Power BI Report Server
Likewise, if I go to the PBIRS web portal (http://server/reports) and attempt to use the Upload button to upload a pbix file, I get the error message
An error has occurred. / Something went wrong. Please try again later.
Things we've tried:
Ideas?
Solved! Go to Solution.
Couple quick questions:
1. Are you using the May preview release of PBIRS?
2. Do you have the preview release of SSRS 2017 installed?
There was an issue in the preview edition of the PBIRS config tool which wasn't registering a URL correctly but there is a work around for it. If this is the same issue you should see and 'System.Net.HttpListenerException: Access is denied' error in the RSPowerBI log file. I posted the workaround here:
Also one other thing you can check is you can run the following from an admin command prompt on the server:
netsh http show urlacl
You should see a url reservation for http://+:<port number>/powerbi (or https) if you don't then the workaround above should work for you. You shouldn't have to add the user to the administators group. If your not using the preview edition then this may be another issue.
Hi there,
Sorry that you are hitting this issue, but we'll need a bit more information to get to the bottom of it. Could you provide me logs from the Power BI Report Server. By default these logs are in: C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\
The three we'd be most intersted in is RSPowerBI_*.log, ReportingServicesService_*.log & RSPortal_*.log where * will be a datetime. Could you do me a favor and try to upload the report, get the error, and then copy the latest logs or snippits from the logs. I know you took a look at the logs, but I'm hoping something pops out in one of these missed on the first glance.
-Pete
I added log snippets to the issues post, but here's a One Drive link to the full files, including those before and after the error.
The logs look like they were moved or the url changed? I get this error from sharepoint.com:
So one of my techs made some progress and got Power BI Reports working on PBIRS for now. The service account used in RS Configuration Manager was not a local administrator on the server. As soon as he replaced the service account we had in the past used with SSRS with a user that is a local administrator on the server, we were able to get PBI Reports working on PBIRS.
The tech's hypothesis was that it has something to do with URL reservations, but I'm not 100% sure that's right since everything else about PBIRS was working except PBI Reports. In any case, changing the service account made it work.
I will say we're not willing at this point to allow the PBIRS service account to be a local administrator on a permanent basis. We're going to experiment with making the regular service account a local administrator, getting things set up, then removing local administrator rights from that user to see if things will continue to work in that manner. If that fails, then unless Microsoft gives us an unambiguous notice that the service account MUST be a local administrator, we don't see a reasonable way to move forward.
Of course I hit send and *then* get the results of the experiment. From my tech:
ok, the account has to be in the local admin group in order to work. i changed the account like discussed after adding it to the local admin group. the urls renewed and i was able to upload. then i deleted the account from local admin, restarted the service and then i could NOT upload anymore. i added the account back to the local admin and restarted the service and then i could upload again.
Couple quick questions:
1. Are you using the May preview release of PBIRS?
2. Do you have the preview release of SSRS 2017 installed?
There was an issue in the preview edition of the PBIRS config tool which wasn't registering a URL correctly but there is a work around for it. If this is the same issue you should see and 'System.Net.HttpListenerException: Access is denied' error in the RSPowerBI log file. I posted the workaround here:
Also one other thing you can check is you can run the following from an admin command prompt on the server:
netsh http show urlacl
You should see a url reservation for http://+:<port number>/powerbi (or https) if you don't then the workaround above should work for you. You shouldn't have to add the user to the administators group. If your not using the preview edition then this may be another issue.
We are using the GA release in trial mode (though we do have SQL Server 2016 Enterprise w/ Software Assurance, so that's how we'll license in dev/qa/prod once we get deployment issues worked out in sandbox). We do not have SSRS 2017 installed.
Before installing PBIRS June GA, we previously had SSRS 2016 and PBIRS May Preview. We uninstalled May Preview, installed June GA, and then stopped the SSRS 2016 service.
What is the relevance of SSRS 2017?
There are some side by side issues between SSRS 2017 and PBIRS Previews however since you didn't have that installed it's not relevant. I do think this still could be a URL reservation issue. Can you run the netsh command at let me know what Reserved URL entries you have for SSRS 2016 and PBIRS. For SSRS (User: NT SERVICE\ReportServer) you should have two /reportserver and /reports (assuming you didn't change the name of the RS virtual directories. For PBIRS (User: NT SERVICE\PowerBIReportServer) you should see four URL reservations /reportserver, /reports, /powerbi and //+:8083.
One other quick question, did you use the same URL ports that you used for the PBIRS May preview with the GA install? Thanks!
Our tech tried the workaround for URL reservations issue and it worked. We've now got PBIRS June GA running with our normal SSRS service account not in the local admin group and we can deploy Power BI reports.
It appears the URL reservations issue persists in GA.
For the sake of posterity, here is what our reservations currently look like:
Reserved URL : http://+:8083/ User: NT SERVICE\PowerBIReportServer Listen: Yes Delegate: No SDDL: (snip) Reserved URL : http://+:80/ReportServer/ User: NT SERVICE\PowerBIReportServer Listen: Yes Delegate: No SDDL: (snip) Reserved URL : http://LocalHost:80/ReportServer/ User: NT SERVICE\PowerBIReportServer Listen: Yes Delegate: No SDDL: (snip) Reserved URL : https://+:443/ReportServer/ User: NT SERVICE\PowerBIReportServer Listen: Yes Delegate: No SDDL: (snip) Reserved URL : http://+:80/Reports/ User: NT SERVICE\PowerBIReportServer Listen: Yes Delegate: No SDDL: (snip) Reserved URL : http://+:80/PowerBI/ User: NT SERVICE\PowerBIReportServer Listen: Yes Delegate: No SDDL: (snip) Reserved URL : http://LocalHost:80/Reports/ User: NT SERVICE\PowerBIReportServer Listen: Yes Delegate: No SDDL: (snip) Reserved URL : http://LocalHost:80/PowerBI/ User: NT SERVICE\PowerBIReportServer Listen: Yes Delegate: No SDDL: (snip) Reserved URL : https://+:443/Reports/ User: NT SERVICE\PowerBIReportServer Listen: Yes Delegate: No SDDL: (snip) Reserved URL : https://+:443/PowerBI/ User: NT SERVICE\PowerBIReportServer Listen: Yes Delegate: No SDDL: (snip)
(xpost Report Server Forum)
We're practicing replacing SSRS with PBIRS. We've successfully installed and (mostly?) configured PBIRS such that it will happily run "Paginated Reports" (aka old style SSRS reports). However, we cannot save a Power BI report to PBIRS!
I'm using the June 2017 version of PBI Desktop. When I create the report - using a live AS connection, of course - and try to Save As to the PBIRS instance, I get the error message:
Saving to Power BI Report Server / An error occurred while attempting to save the report to Power BI Report Server
Likewise, if I go to the PBIRS web portal (http://server/reports) and attempt to use the Upload button to upload a pbix file, I get the error message
An error has occurred. / Something went wrong. Please try again later.
Things we've tried:
Ideas?
Relevant bit from PBI Desktop RS June 2017 trace:
DataMashup.Trace Information: 24579 : {"Start":"2017-06-21T14:16:14.2982840Z","Action":"PackageSessionStorage/GetSessionStorage","PackageReference":[["97224ebe-3fcf-426e-a491-41095a2b4c0d"],[2]],"ProductVersion":"2.47.4766.581 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":13792,"Tid":1,"Duration":"00:00:00.0000371"} DataMashup.Trace Information: 24579 : {"Start":"2017-06-21T14:16:14.2983140Z","Action":"PackageStorage/Access","PackageReference":[["97224ebe-3fcf-426e-a491-41095a2b4c0d"],[2]],"ProductVersion":"2.47.4766.581 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":13792,"Tid":1,"Duration":"00:00:00.0012510"} DataMashup.Trace Warning: 24579 : {"Start":"2017-06-21T14:16:14.3044678Z","Action":"PBI.PQ.SaveDiscardInternal","Message":"{\"actionId\":\"SaveDocumentInternal\",\"entryPoint\":\"EditorRibbonButtonPowerBISharePublish\",\"errorCode\":\"\",\"message\":\"\",\"wasRetried\":\"False\",\"retryReason\":\"\",\"parentId\":\"7ed5350a-290d-41f3-ab50-456f2f20a862\",\"isError\":\"False\",\"sessionId\":\"e8de7d60-25fd-40b5-8a8f-0b26b8addbc1\",\"deviceId\":\"bc30256b\",\"userId\":\"b7da30db-7a07-448b-83c3-4f2dbc1fc57b\",\"isInternal\":\"False\",\"authenticatedUserId\":\"650b6d94-3524-40ee-93d9-3ae7f2596437\"}","ProductVersion":"2.47.4766.581 (PBIDesktop)","ActivityId":"1e178145-b7fe-4119-8079-7ccab773dec8","Process":"PBIDesktop","Pid":13792,"Tid":1,"Duration":"-00:00:00.0014368"} DataMashup.Trace Information: 24579 : {"Start":"2017-06-21T14:16:14.7868605Z","Action":"JsonSerializer/TryDeserialize","Result":true,"ProductVersion":"2.47.4766.581 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":13792,"Tid":1,"Duration":"00:00:00.0008910"} DataMashup.Trace Warning: 24579 : {"Start":"2017-06-21T14:16:14.3399687Z","Action":"PBI.Win.SaveReportToSSRS","Message":"{\"result\":\"UnexpectedError\",\"parentId\":\"7ed5350a-290d-41f3-ab50-456f2f20a862\",\"isError\":\"True\",\"sessionId\":\"e8de7d60-25fd-40b5-8a8f-0b26b8addbc1\",\"deviceId\":\"bc30256b\",\"userId\":\"b7da30db-7a07-448b-83c3-4f2dbc1fc57b\",\"isInternal\":\"False\",\"authenticatedUserId\":\"650b6d94-3524-40ee-93d9-3ae7f2596437\"}","ProductVersion":"2.47.4766.581 (PBIDesktop)","ActivityId":"8269a95d-e205-44cd-ad23-b97749126a50","Process":"PBIDesktop","Pid":13792,"Tid":1,"Duration":"00:00:00.5834962"} DataMashup.Trace Information: 24579 : {"Start":"2017-06-21T14:16:16.7159490Z","Action":"PackageSessionStorage/GetSessionStorage","PackageReference":[["97224ebe-3fcf-426e-a491-41095a2b4c0d"],[2]],"ProductVersion":"2.47.4766.581 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":13792,"Tid":1,"Duration":"00:00:00.0000690"} DataMashup.Trace Information: 24579 : {"Start":"2017-06-21T14:16:16.7160070Z","Action":"PackageStorage/Access","PackageReference":[["97224ebe-3fcf-426e-a491-41095a2b4c0d"],[2]],"ProductVersion":"2.47.4766.581 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"PBIDesktop","Pid":13792,"Tid":1,"Duration":"00:00:00.0003521"}
This is the tail of RSHostingService_2017_06_21_13_20_52.txt from server (as you see, no messages near time of error):
2017-06-21 13:36:24.6721|INFO|8|Throttled restart of process by 479,312.50ms: PowerBI 2017-06-21 13:36:24.6721|INFO|8|Launching Process : PowerBI 2017-06-21 13:36:24.6721|INFO|8|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\PowerBI\RSPowerBI.exe 2017-06-21 13:36:25.3440|WARN|15|Child Process [PowerBI] Died. Check the log for further information 2017-06-21 13:52:24.6801|INFO|8|Throttled restart of process by 959,328.12ms: PowerBI 2017-06-21 13:52:24.6801|INFO|8|Launching Process : PowerBI 2017-06-21 13:52:24.6801|INFO|8|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\PowerBI\RSPowerBI.exe 2017-06-21 13:52:25.3520|WARN|18|Child Process [PowerBI] Died. Check the log for further information
There is no RSPowerBI log for the relevant time, but here's the latest log since the error, appears to correlate with restarting of service:
2017-06-21 14:24:24.8893|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 2736 2017-06-21 14:24:24.9830|INFO|1|CFG : Dumper.path = [..\LogFiles\] (env) 2017-06-21 14:24:24.9830|INFO|1|CFG : Name = [] (env) 2017-06-21 14:24:24.9830|INFO|1|CFG : Dumper.flags = [SendToWatson, AllThreads, AllMemory] (env) 2017-06-21 14:24:24.9830|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-06-21 14:24:24.9830|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-06-21 14:24:24.9830|INFO|1|Provider name 2017-06-21 14:24:24.9830|INFO|1|Container name Microsoft SQL Server Reporting Services Key Container 2010 2017-06-21 14:24:24.9830|INFO|1|CFG : rsConfigFilePath = [C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config] (env) 2017-06-21 14:24:24.9830|INFO|1|CFG : Hosting-databaseValidationStatus = [Valid] (env) 2017-06-21 14:24:24.9830|INFO|1|CFG : Hosting-managementUrl = [http://localhost:8083/] (env) 2017-06-21 14:24:24.9830|INFO|1|CFG : Hosting-featureSwitches = [e30=] (env) 2017-06-21 14:24:25.0924|INFO|1|CFG : Hosting-portalUrl = [http://localhost/Reports] (env) 2017-06-21 14:24:25.0924|INFO|1|CFG : Hosting-encryptionKey = [AQIAAANmAAAApAAAVNXNtomD28kSphoB2CJDp4+QKWIf6ko5mlt4hF6UuRrVgUEHrcw5+1t3VFTPtxt+lH0vMHU2gcCh3SUS8XjcsWEAtUT44Z0X70KNKmHiI1qq/KFiRfoUmrBXZqzwJwfwUg0Zc6FLTfgUV+knH1zGNPr9XdKNMK89YV2B5CMEs2eQlEHDUMg2cy+dOHRitW/DjTfgHsgnxyXS5nHOJp/jjxU07uK2Tmee9Iw+0X4sRAve76pC4kHBI+CLfbUh24VqE7ABdOiGKeZZXYD3AT0Gx9dtZYPS2wXsxiIUC65szkoin8oMQ39YIuyiKvhqE1jSvJlwHLtVxkI62nYd8BynVQ==] (env) 2017-06-21 14:24:25.0924|INFO|1|Setting Symmetric Key 2017-06-21 14:24:25.1080|INFO|1|Setting up Hosted Process State 2017-06-21 14:24:25.1080|INFO|1|CFG : rsConfigFilePath = [C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config] (env) 2017-06-21 14:24:25.1080|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-06-21 14:24:25.3268|FATAL|1|Could not start PBIXSystem.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.HttpListenerException: Access is denied at System.Net.HttpListener.AddAllPrefixes() at System.Net.HttpListener.Start() at Microsoft.Owin.Host.HttpListener.OwinHttpListener.Start(HttpListener listener, Func`2 appFunc, IList`1 addresses, IDictionary`2 capabilities, Func`2 loggerFactory) at Microsoft.Owin.Host.HttpListener.OwinServerFactory.Create(Func`2 app, IDictionary`2 properties) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Microsoft.Owin.Hosting.ServerFactory.ServerFactoryAdapter.Create(IAppBuilder builder) at Microsoft.Owin.Hosting.Engine.HostingEngine.Start(StartContext context) at Microsoft.PowerBI.ReportServer.WebHost.Program.Main(String[] args)
And here's the log before, ends well before error in question
2017-06-21 13:52:24.8676|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 1504 2017-06-21 13:52:24.9613|INFO|1|CFG : Dumper.path = [..\LogFiles\] (env) 2017-06-21 13:52:24.9613|INFO|1|CFG : Name = [] (env) 2017-06-21 13:52:24.9613|INFO|1|CFG : Dumper.flags = [SendToWatson, AllThreads, AllMemory] (env) 2017-06-21 13:52:24.9613|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-06-21 13:52:24.9613|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-06-21 13:52:24.9613|INFO|1|Provider name 2017-06-21 13:52:24.9613|INFO|1|Container name Microsoft SQL Server Reporting Services Key Container 2010 2017-06-21 13:52:24.9613|INFO|1|CFG : rsConfigFilePath = [C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config] (env) 2017-06-21 13:52:24.9613|INFO|1|CFG : Hosting-databaseValidationStatus = [Valid] (env) 2017-06-21 13:52:24.9613|INFO|1|CFG : Hosting-managementUrl = [http://localhost:8083/] (env) 2017-06-21 13:52:24.9613|INFO|1|CFG : Hosting-featureSwitches = [e30=] (env) 2017-06-21 13:52:25.0707|INFO|1|CFG : Hosting-portalUrl = [http://localhost/Reports] (env) 2017-06-21 13:52:25.0707|INFO|1|CFG : Hosting-encryptionKey = [AQIAAANmAAAApAAAVNXNtomD28kSphoB2CJDp4+QKWIf6ko5mlt4hF6UuRrVgUEHrcw5+1t3VFTPtxt+lH0vMHU2gcCh3SUS8XjcsWEAtUT44Z0X70KNKmHiI1qq/KFiRfoUmrBXZqzwJwfwUg0Zc6FLTfgUV+knH1zGNPr9XdKNMK89YV2B5CMEs2eQlEHDUMg2cy+dOHRitW/DjTfgHsgnxyXS5nHOJp/jjxU07uK2Tmee9Iw+0X4sRAve76pC4kHBI+CLfbUh24VqE7ABdOiGKeZZXYD3AT0Gx9dtZYPS2wXsxiIUC65szkoin8oMQ39YIuyiKvhqE1jSvJlwHLtVxkI62nYd8BynVQ==] (env) 2017-06-21 13:52:25.0707|INFO|1|Setting Symmetric Key 2017-06-21 13:52:25.0707|INFO|1|Setting up Hosted Process State 2017-06-21 13:52:25.0707|INFO|1|CFG : rsConfigFilePath = [C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config] (env) 2017-06-21 13:52:25.0863|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-06-21 13:52:25.3051|FATAL|1|Could not start PBIXSystem.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.HttpListenerException: Access is denied at System.Net.HttpListener.AddAllPrefixes() at System.Net.HttpListener.Start() at Microsoft.Owin.Host.HttpListener.OwinHttpListener.Start(HttpListener listener, Func`2 appFunc, IList`1 addresses, IDictionary`2 capabilities, Func`2 loggerFactory) at Microsoft.Owin.Host.HttpListener.OwinServerFactory.Create(Func`2 app, IDictionary`2 properties) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Microsoft.Owin.Hosting.ServerFactory.ServerFactoryAdapter.Create(IAppBuilder builder) at Microsoft.Owin.Hosting.Engine.HostingEngine.Start(StartContext context) at Microsoft.PowerBI.ReportServer.WebHost.Program.Main(String[] args)