Forum Discussion
Cannot Publish Power BI Report
We have a dev, test, and production environment for Power BI Report Server. The dev and test environment are setup on stand alone servers with both front end web server and back end SQL database on each box respectively. These servers work fine. However the production server is setup with seperate servers for the SQL back end, and web front end; each on their own box.
We can upload paginated reports, excel spreadsheets, and so on to the production server. It only errors whenever we try and save Power BI Reports to the server.
Here is the error when trying to "Save As" to the prod server:
Here is the error from the RSPortal Log file:
2018-05-01 09:41:33.0040|INFO|243|Received request GET /api/v2.0/ServiceState| RequestID = s_2694c56e-3ad9-4809-881a-4e8a39290c9c 2018-05-01 09:41:33.0196|INFO|243|Sending response. Response code "MY DOMAIN LOGIN" 200, Elapsed time 0:00:00.0126308| RequestID = s_2694c56e-3ad9-4809-881a-4e8a39290c9c 2018-05-01 09:41:33.3790|INFO|242|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/%27%29| RequestID = s_a386a27d-a4b0-41e1-85f2-11ba4e856ddb 2018-05-01 09:41:33.3946|INFO|242|Sending response. Response code "MY DOMAIN LOGIN" 200, Elapsed time 0:00:00.0051512| RequestID = s_a386a27d-a4b0-41e1-85f2-11ba4e856ddb 2018-05-01 09:41:33.4571|INFO|242|Received request GET /api/v2.0/catalogitems%285fb050f4-d75b-4ffb-95f4-5d060618d6e9%29/Model.Folder/catalogitems/| RequestID = s_062d5418-f596-40e0-b875-b47760de5835 2018-05-01 09:41:33.5040|INFO|250|Sending response. Response code "MY DOMAIN LOGIN" 200, Elapsed time 0:00:00.0470726| RequestID = s_062d5418-f596-40e0-b875-b47760de5835 2018-05-01 09:41:37.7071|INFO|242|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/UHNow%20Provider%20Location%27%29| RequestID = s_2eb9faac-699f-4c8c-8e8b-ed030d4e58fb 2018-05-01 09:41:37.7071|INFO|242|Sending response. Response code "MY DOMAIN LOGIN" 404, Elapsed time 0:00:00.0032176| RequestID = s_2eb9faac-699f-4c8c-8e8b-ed030d4e58fb 2018-05-01 09:41:39.3946|INFO|319|Received request GET /api/v2.0/System/Properties| RequestID = s_e8c0b51c-b323-4bee-b8c6-254a592fb95b 2018-05-01 09:41:39.3946|INFO|319|Sending response. Response code "MY DOMAIN LOGIN" 200, Elapsed time 0:00:00.0027435| RequestID = s_e8c0b51c-b323-4bee-b8c6-254a592fb95b 2018-05-01 09:41:39.6290|INFO|242|Received request GET /api/v2.0/me| RequestID = s_b41eb733-9f19-4744-94e9-d83c4670a4f1 2018-05-01 09:41:39.7853|INFO|242|Sending response. Response code "MY DOMAIN LOGIN" 200, Elapsed time 0:00:00.1689942| RequestID = s_b41eb733-9f19-4744-94e9-d83c4670a4f1 2018-05-01 09:41:39.8946|INFO|319|Received request POST /api/v2.0/powerbireports%28Path%3D%27/UHNow%20Provider%20Location%27%29/Model.Upload| RequestID = s_6cd54288-061f-400a-8981-89c5a89c6487 2018-05-01 09:41:40.5821|INFO|251|CFG : InterProcessTimeoutMinutes = [30] (env) 2018-05-01 09:41:40.5821|ERROR|251|The remote server returned an error: (503) Server Unavailable.| RequestID = s_6cd54288-061f-400a-8981-89c5a89c6487 2018-05-01 09:41:40.5821|INFO|250|Sending response. Response code "MY DOMAIN LOGIN" 422, Elapsed time 0:00:00.6973017| RequestID = s_6cd54288-061f-400a-8981-89c5a89c6487
This is the RSPowerBI log:
2018-05-01 11:46:42.3014|INFO|1|File Logger created: C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPowerBI_2018_05_01_11_46_42.log - level Info, will roll at 32 Mb, process id 5908 2018-05-01 11:46:42.4106|INFO|1|CFG : Dumper.path = [..\LogFiles\] (env) 2018-05-01 11:46:42.4106|INFO|1|CFG : Name = [] (env) 2018-05-01 11:46:42.4106|INFO|1|CFG : Dumper.flags = [SendToWatson, AllThreads, AllMemory] (env) 2018-05-01 11:46:42.4106|INFO|1|CFG : Dumper.preventIfContains = [Microsoft.PowerBI.ReportServer.WebApi.Catalog.CatalogAccessException,System.Threading.ThreadAbortException,System.OutOfMemoryException,System.ObjectDisposedException,System.IO.IOException,System.IO.FileLoadException,System.AppDomainUnloadedException,System.Net.Http.HttpRequestException,System.Net.HttpListenerException,System.OperationCanceledException,System.InvalidOperationException] (env) 2018-05-01 11:46:42.4106|INFO|1|Do not dump on: Microsoft.PowerBI.ReportServer.WebApi.Catalog.CatalogAccessException,System.Threading.ThreadAbortException,System.OutOfMemoryException,System.ObjectDisposedException,System.IO.IOException,System.IO.FileLoadException,System.AppDomainUnloadedException,System.Net.Http.HttpRequestException,System.Net.HttpListenerException,System.OperationCanceledException,System.InvalidOperationException 2018-05-01 11:46:42.4106|INFO|1|Provider name 2018-05-01 11:46:42.4106|INFO|1|Container name Microsoft SQL Server Reporting Services Key Container 2010 2018-05-01 11:46:42.4106|INFO|1|CFG : rsConfigFilePath = [C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config] (env) 2018-05-01 11:46:42.4106|INFO|1|CFG : Hosting-databaseValidationStatus = [Valid] (env) 2018-05-01 11:46:42.4106|INFO|1|CFG : Hosting-url-ManagementService = [http://uhprbiprdrpt01:8083/] (env) 2018-05-01 11:46:42.4106|INFO|1|CFG : Hosting-url-ReportServerWebApp = [http://uhprbiprdrpt01/Reports] (env) 2018-05-01 11:46:42.4106|INFO|1|CFG : Hosting-encryptionKey = EncryptionKeyHERE 2018-05-01 11:46:42.4106|INFO|1|Setting Symmetric Key 2018-05-01 11:46:42.4263|INFO|1|Setting up Hosted Process State 2018-05-01 11:46:42.4263|INFO|1|CFG : rsConfigFilePath = [C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config] (env) 2018-05-01 11:46:42.4575|INFO|1|CFG : ASPort = [5132] (env) 2018-05-01 11:46:42.4575|INFO|1|CFG : ModelCleanupCycleMinutes = [15] (env) 2018-05-01 11:46:42.4575|INFO|1|CFG : ModelExpirationMinutes = [60] (env) 2018-05-01 11:46:42.4575|INFO|1|CFG : ScheduleRefreshTimeoutMinutes = [120] (env) 2018-05-01 11:46:42.4575|INFO|1|CFG : TimerInitialDelaySeconds = [60] (env) 2018-05-01 11:46:42.4575|INFO|1|CFG : Hosting-url-ReportServerWebApp = [Server HERE] (env) 2018-05-01 11:46:42.4731|INFO|5|XEvent logging disabled in current LogLevel 2018-05-01 11:46:42.4888|INFO|1|CFG : TimerInitialDelaySeconds = [60] (env) 2018-05-01 11:46:42.5513|INFO|1|CFG : SecureConnectionLevel = [0] (env) 2018-05-01 11:46:42.7231|INFO|1|CFG : MaxActiveReqForOneUser = [20] (env) 2018-05-01 11:46:42.7231|INFO|1|CFG : MaxActiveReqForAnonymous = [200] (default) 2018-05-01 11:46:42.7388|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() 2018-05-01 11:46:42.7388|INFO|1|Logger shutting down
All -
I finally unistalled everything (even dropping the reportserver and tempreportesrver databases), and re-installed fresh. This seemed to resolve the issue as I am now able to publish Power BI reports either via the "Save as" option or uploading from the Power BI portal.
To uninstall simply run the setup and choose the ininstall option. Finish up by using SSMS to drop the associated databases.
I'm assuming this happened after updating Power BI from one version to another.
9 Replies
can you try few things
on the report portal,
1. can you try to detele a existing file
2. are you able to upload that pxib directly from report portal
3. i think it's about infrastructure issue.
It looks like there may have been an issue setting up the Power BI endpoint which handles PBI report requests or the service account you have setup has limited permissions. Can you try running the following command and let me know if you see an entry for a PBI endpoint, should look similar to (Reserved URL: http://+:80/powerbi/) however the port number should match whatever port you used in the config tool. Additionaly can you check the config tool and let me know what you have set for your service account, you may also want to compare it to what you have configured for your other environments.
netsh http show urlacl
Matt M.
1. can you try to detele a existing file - On the server and web portal: Yes, I can delete files on the server and anything currently on the web portal.
2. are you able to upload that pxib directly from report portal - no, this also results in an even more generic error.
3. i think it's about infrastructure issue. - Probably
I ran the command and the "Reserved URL: http://+:80/powerbi/" line does exist. As far as the user account it is just the default PowerBI NT Service account being used. This is the same for the other environement. The SQL connection uses a AD service account we created.
