Cannot Save As/Upload PBIX to Report Server
Running Power BI Report Server Version 1.6.7364.4075 (January 2020) Running Power BI Desktop optimised for Report Server 2.76.5678.1521 64-bit (January 2020). Paginated Reports render fine, I can browser the RSPortal fine and I can use Report Builder fine. I have a test PBIX file with nothing but a Text box, cannot Save As to the Report Server within Power BI Desktop; produced error "An error occured while attempting to save the report to Power BI Report Server" If I save the PBIX to local file system and upload it directly through the RSPortal, I instead get the 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.". Reopening the same file in Power BI Desktop is fine. The folder on the Report Server that the PBIX is being uploaded to has the appropriate permissions for the user/security principal Power BI Desktop is being run under and the user that is logged into RSPortal attempting the upload manually. PBIDesktop log does have a warning that is produced when attempting to save the PBIX to the Report Server (I've redacted some metadata): { "Action":"PBI.PQ.SaveDiscardInternal", "actionId":"SaveDocumentInternal", "entryPoint":"EditorRibbonButtonPowerBISharePublish", "errorCode":"UnprocessableEntity", "message":" at Microsoft.PowerBI.Client.Windows.SSRSService.SSRSPbixFile.<Save>d__26.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.PowerBI.Client.Windows.Services.FileManager.<CopyTempToFile>d__27.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.PowerBI.Client.Windows.Services.FileManager.<TrySaveBIPackage>d__22.MoveNext()" } RSPortal log on the server is empty. RSPowerBI, RSOffice, RSManagement, RSHostingService, ReportingServicesService logs show nothing of interest, just normal start-up entries. We have no side-by-side SSRS on the server instances. HTTP(S) bindings for Web Service and Web Portal have been redone. Report Server Service Account has been tried under Network Service and Virtual Service Account, problem exists with both.
PBIRS error updating/overwriting a PBI report file when "local" characters in folder name
PBIRS (march 2018) is having trouble handling certain (all?) non-standard ASCII-characters in folder names. When a folder contains non-standard ASCII a new report gets the name converted to all lower case. If the name of the report is corrected then the report cannot be updated/overwritten from PBI Desktop RS without getting the error "Sorry, you don't have the permission to save in this folder". How to replicate: Create a folder with a non-standard ASCII like a umlaut 'ä'. For example the name 'Blä' Create a new report with the name "Abc" in Power BI Desktop RS and save it in that folder. There is no error message, but the name of the report is converted to lower case (abc). This is not the case if the folder's name would have been 'Bla' Now choose Manage for the report and change the name to Abc If now try to overwrite the report from PBI Desktop RS, or update it using "Edit in Power BI Desktop" from within the PBIRS-page and then choose "File->Save" i PBI Desktop RS, you will get the error "Sorry, you don't have the permission to save in this folder" If you at this point change the folder name to 'Bla' then you can overwrite/update the report without error. You will also run into the similar problems if the report's name contins these characters. This makes it quite annoying to update reports that are saved in PBIRS. The workaround is to Choose "Edit in Power BI Desktop" Make the changes Delete the report from PBIRS Save the report as a new report Change the name to the correct upper and lower case name Update the report's description since it is lost The collation of the report database (PBIReportServer) is Latin1_General_100_CI_AS_KS_WS Hope this can be fixed! /Daniel