Unable to publish to Power BI Report Server

Sowjanyapbi — Tue, 24 Oct 2023 06:18:36 GMT

Hi. I am unable to publish the Power BI reports to Power BI Report Server. PBI RS is in a different server and I have windows Administrator and SQL sysadmin permissions on it. I also have System Administrator role in the Site Settings and Content Manager, Publisher, Report Builder roles on the RS web portal. I am trying to upload locally by doing rdp to the server. I am unable to upload or publish but the existing Administrator of that server is able to upload/publish the same reports. Please let me know what additional permissions do I need.

Getting the error "An error has occured. Something went wrong. Please try again later" while trying to upload the report.

Getting the error "An error occurred while attempting to save the report to Power BI Report Server" when trying to open it & save to Power BI.

I checked the Report Server log & I find below.

Received a request with an unmatched or no authentication scheme. 401

2023-10-23 16:42:07.2475|WARN|50|Received a request with an unmatched or no authentication scheme. 401 RequestUri:http://127.0.0.1:7790/rep/api/v2.0/CatalogItems(Path='/Tableau Migration')/AllowedActions Content-Length:0 HTTP Method:GET
2023-10-23 16:42:07.2475|WARN|50|Received a request with an unmatched or no authentication scheme. 401 RequestUri:http://127.0.0.1:7790/rep/api/v2.0/System/Properties?properties=TileViewByDefault Content-Length:0 HTTP Method:GET
2023-10-23 16:42:07.2475|WARN|68|Received a request with an unmatched or no authentication scheme. 401 RequestUri:http://127.0.0.1:7790/rep/assets/img/fi/pbirs/favicon.ico Content-Length:0 HTTP Method:GET
2023-10-23 16:42:07.2475|INFO|50|Received request GET /api/v2.0/System/Properties| RequestID = s_ca3f3439-f0dd-4f45-8594-bfbab75c0c4f
2023-10-23 16:42:07.2597|INFO|20|Received request GET /api/v2.0/CatalogItems(Path='/Tableau%20Migration')/AllowedActions| RequestID = s_bed80153-0c45-4223-9b0e-d0878c43d664
2023-10-23 16:42:07.2597|INFO|69|Sending response. Response code CUBE\PBITest 200, Elapsed time 0:00:00.0058973| RequestID = s_ca3f3439-f0dd-4f45-8594-bfbab75c0c4f
2023-10-23 16:42:07.2597|INFO|80|Received request GET /assets/img/fi/pbirs/favicon.ico| RequestID = s_52e5bc8d-6af4-4cca-a6d7-1bcbb263b58a
2023-10-23 16:42:07.2597|INFO|50|Received request GET /api/v2.0/CatalogItems(Path='/Tableau%20Migration')| RequestID = s_0dacab42-3091-4f11-9844-3b35da60141f
2023-10-23 16:42:07.2597|INFO|80|Received request GET /api/v2.0/Folders(Path='/Tableau%20Migration')/AllowedActions| RequestID = s_7bd477bb-9f20-4dc7-9d7b-f531fcb047f1
2023-10-23 16:42:07.2597|WARN|68|Received a request with an unmatched or no authentication scheme. 401 RequestUri:http://127.0.0.1:7790/rep/assets/img/fi/pbirs/favicon.ico Content-Length:0 HTTP Method:GET
2023-10-23 16:42:07.2757|INFO|191|Sending response. Response code CUBE\PBITest 200, Elapsed time 0:00:00.0153548| RequestID = s_bed80153-0c45-4223-9b0e-d0878c43d664
2023-10-23 16:42:07.2757|INFO|68|Received request GET /assets/img/fi/pbirs/favicon.ico| RequestID = s_335a3a32-0f98-4fed-9d04-ce977715bc52
2023-10-23 16:42:07.2757|INFO|88|Sending response. Response code CUBE\PBITest 200, Elapsed time 0:00:00.0126544| RequestID = s_0dacab42-3091-4f11-9844-3b35da60141f
2023-10-23 16:42:07.2757|INFO|50|Received request GET /api/v2.0/catalogitems(9bf2e150-4788-4fef-a741-07dda6e6b264)/Model.Folder/catalogitems/| RequestID = s_5028ea59-9ef4-409c-a548-3cb0a1af5477
2023-10-23 16:42:07.3142|INFO|56|Sending response. Response code CUBE\PBITest 200, Elapsed time 0:00:00.0286012| RequestID = s_5028ea59-9ef4-409c-a548-3cb0a1af5477
2023-10-23 16:42:07.5580|INFO|191|Sending response. Response code CUBE\PBITest 200, Elapsed time 0:00:00.2871259| RequestID = s_7bd477bb-9f20-4dc7-9d7b-f531fcb047f1
2023-10-23 16:42:33.4439|INFO|80|Received request GET /api/v2.0/CatalogItems(Path='/Tableau%20Migration/Omantel_2_BAT_3')| RequestID = s_d64a74e6-14ad-455d-9c6e-a2d7536ce00b
2023-10-23 16:42:33.4439|ERROR|80|library|Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/Tableau Migration/Omantel_2_BAT_3' cannot be found.;| RequestID = s_d64a74e6-14ad-455d-9c6e-a2d7536ce00b
2023-10-23 16:42:33.4500|INFO|56|Sending response. Response code CUBE\PBITest 404, Elapsed time 0:00:00.0063318| RequestID = s_d64a74e6-14ad-455d-9c6e-a2d7536ce00b

Please help me in finding what permissions are missing.

Re: Unable to publish to Power BI Report Server

d_gosbell — Tue, 24 Oct 2023 06:18:06 GMT

You don't need admin rights on the local server or on SQL to upload reports. You should just need content manager or publisher rights on the folder.

It looks like maybe something has gone wrong with your url reservations. I've never seen that sort of error before and I think you will need to raise a ticket with Microsoft Support to get this sorted out. This looks like something has been misconfigured.

topic Unable to publish to Power BI Report Server in Report Server

Unable to publish to Power BI Report Server

Re: Unable to publish to Power BI Report Server