cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jayeckles Advocate II
Advocate II

PBIRS up and running, but can't save PBI reports!

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

  • connecting to Power BI through Report Server Configuration Manager
  • Rebooting server
  • Rebooting client machine
  • Saving to PBIRS from the server
  • Uploading to PBIRS from the server
  • Reviewing PBIRS log files (there are no messages at all I see regarding this error)
  • Reviewing PBI Desktop RS trace file (there are messages indicating an error, but no detail at all)

Ideas?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Team mgmeyer
Power BI Team

Re: PBIRS up and running, but can't save PBI reports!

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:

 

http://community.powerbi.com/t5/Desktop/Power-BI-Report-server-Issue-with-deploying-power-bi-report/...

 

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.

View solution in original post

11 REPLIES 11
jayeckles Advocate II
Advocate II

Cannot save Power BI Report to PBIRS

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

  • connecting to Power BI through Report Server Configuration Manager
  • Rebooting server
  • Rebooting client machine
  • Saving to PBIRS from the server
  • Uploading to PBIRS from the server
  • Reviewing PBIRS log files (there are no messages at all I see regarding this error)
  • Reviewing PBI Desktop RS trace file (there are messages indicating an error, but no detail at all)

Ideas?

jayeckles Advocate II
Advocate II

Re: Cannot save Power BI Report to PBIRS

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)
Petebro Resolver I
Resolver I

Re: PBIRS up and running, but can't save PBI reports!

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

jayeckles Advocate II
Advocate II

Re: PBIRS up and running, but can't save PBI reports!

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.

 

https://liveutk-my.sharepoint.com/personal/jeckles1_utk_edu/_layouts/15/guestaccess.aspx?folderid=0d...

Petebro Resolver I
Resolver I

Re: PBIRS up and running, but can't save PBI reports!

The logs look like they were moved or the url changed? I get this error from sharepoint.com:

 

This link has been removed.
 
 
Sorry, access to this document has been removed. Please contact the person who shared it with you
jayeckles Advocate II
Advocate II

Re: PBIRS up and running, but can't save PBI reports!

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.  

la.png

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.

jayeckles Advocate II
Advocate II

Re: PBIRS up and running, but can't save PBI reports!

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.

Power BI Team mgmeyer
Power BI Team

Re: PBIRS up and running, but can't save PBI reports!

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:

 

http://community.powerbi.com/t5/Desktop/Power-BI-Report-server-Issue-with-deploying-power-bi-report/...

 

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.

View solution in original post

jayeckles Advocate II
Advocate II

Re: PBIRS up and running, but can't save PBI reports!

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?

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications