Forum Discussion
Error when saving report to Power BI Report Server
So I reviewed the documentation, identified the correct ports, etc.
When I attempt to save a PBIX file from the Desktop for RS (launched either directly from my desktop or from the Power BI Server), I can see the subdirectories, on the server, but when I attempt to save to those folders
I get an "An error occured while attempting to save the report to Power BI Report Server"
When I attempt to upload a file from my desktop onto the Power BI server via Upload I get the following:
There was an error uploading your .pbix file. Verify that the file has not been corrupted and that the file extension matches the format of the file.
Can anyone help me figure out why I can't save to the server?
38 Replies
Do you have access to the machine that has the server installed? If so can you check the RSPortalXXX and RSPowerBIXXX logs in the installation LogFiles folder and let me know if you see any errors.? Thanks!
Thank you
I am seeing
RSPortal!library!RSPortal.exe!67!11/03/2017-10:41:50:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/Upload/Server Attempt' cannot be found.
Which is the name of the file I am trying to upload.
If you check Help about in Desktop which versoin are you using?
Hi,
I have the same problem. I tried different options including providing the port number - with no luck. My configuration is as follows:
- VM1: Power BI Report Server (October 2017)
- VM2: MS SQL Server 2016 with SSRS installed
So far when someone tries to save the report from Desktop to RS, then gets the error as mentioned in this thread.
Do you have any ideas what may be wrong?
Thanks,
Marcin
A few clean up items for this thread:
There is absolutely no problem running SSRS and PBIRS on the same box, virtual or otherwise.
The report you are trying to upload must be created and/or saved in the --> matching client <-- for the PBIRS version you are using or it will not work.
cmikosThis is a valid point, but we made sure that we had (and still have) the correct versions. And still, on the server we used first it still does not work. On the "new" one it works fine.
The resolution for me was to use the version of PowerBI Desktop which aligns with my Power BI Server version.
In my case, Microsoft Power BI Desktop (Optimized for Power BI Report Server - October 2017)
Located: https://www.microsoft.com/en-us/download/details.aspx?id=56136I had to open existing PBIX files in this version of PowerBI Desktop and resave them. Then, I was able to upload.
Still hasn't worked for me. Running October 2017 Power BI Report Server and October 2017 Power BI Desktop...
Just see these in RSPortal log over and over:
RSPortal!reportserverwebapp!RSPortal.exe!1b!12/12/2017-15:34:45:: i INFO: Received request POST /api/v2.0/powerbireports%28Path%3D%27/Dashboards/Registrants%20State%20Map%27%29/Model.Upload | RequestID = s_dfcb697d-402f-4f70-a1b8-3a6a1f146a9e
RSPortal!library!RSPortal.exe!1b!12/12/2017-15:34:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/Dashboards/Registrants State Map' cannot be found.;
RSPortal!reportserverwebapp!RSPortal.exe!d!12/12/2017-15:34:47:: e ERROR: The remote server returned an error: (401) Unauthorized. | RequestID = s_dfcb697d-402f-4f70-a1b8-3a6a1f146a9eIs this generated by you clicking the "Take me there" link?
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/Dashboards/Registrants State Map' cannot be found.;
That line and the 401 error are a bit strange?
Is there anything published on your server at all?
If so have you re-saved any reports created in previous versions of Power BI with the new version?
Hi All
we are new to PowerBI server and we just installed March 2018 version.
Currently we are facing the same issue with publishing reports to the server using March 2018 Desktop. We configured server with local domain service account and SQL enterprise 2017 Software Assurance.
1. When trying to publish report from Desktop using service account we can select the server and see the folder however we are not able to publish the reports to the selected folder. When using any other user (defined on the portal to have access to the folders) we get error "Unexpected error encountered"
2. When trying to upload PBIX files (even empty) from the portal with both service account and other user, we get error "There was an error uploading your .pbix file. Verify that the file has not been corrupted and that the file extension matches the format of the file."PBIT files are uploaded fine.
Analysis services are not configured. Is it a must for the PowerBI server?
Can the reason be that the user doesn’t have the pro license (to be able to upload) ?
Do we need to set NT service \PowerBI ... account as service account?
In RSPortal xxx log file I can see the error
|ERROR|35|The remote server returned an error: (407) Proxy Authentication Required.| RequestID = s_5f8d70f8-c1a9-4c0d-bcaa-7c9623f00c1a
we have local proxy but it should not be an issue.Any advice is more than welcomed.
Hi,
I was getting the "An error occured while attempting to save the report to Power BI Report Server" error message when trying to publish my PBI reports to PBI Report Server. However, when I downgraded my PBI desktop (optimised for Report Server) to match the Report Server version so in my case uninstalling my desktop version (March 2018) then installing Oct 2017) this did the trick and I was able to publish successfully without any issues.
The other option is to obviously upgrade the Report Server to the latest version (or to match your desktop version) but this should be tested first on non-production systems and it's easier to test locally first before messing with servers.
Hope this helps,
Jay
fix the file rsreportserver.config
Sections:
<Hostname>servername</Hostname> <ReportServerUrl>servername/ReportServer</ReportServerUrl>
