topic Re: PBIRS error updating/overwriting a PBI report file when "local" characters in folder name in Report Server

PBIRS error updating/overwriting a PBI report file when "local" characters in folder name

DanielAdler — Fri, 18 May 2018 16:22:05 GMT

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

Re: PBIRS error updating/overwriting a PBI report file when "local" characters in folder name

Anonymous — Wed, 19 Sep 2018 09:35:42 GMT

This error still exists in Release August 2018.

Re: PBIRS error updating/overwriting a PBI report file when "local" characters in folder name

DanielAdler — Thu, 20 Sep 2018 21:08:27 GMT

I actually found a bit easier workaround that doesn't include delting the report from PBIRS. Instead, choose Manage report and change the name to be only lower case letters (I'm not sure this goes for all the folders as well). After this the report can be saved and after that the report name can be changed back to whatever the name should be. This way the report is not deleted and keeps the same reportid which is useful when collecting usage statistics.

Re: PBIRS error updating/overwriting a PBI report file when "local" characters in folder name

StephaneS — Tue, 20 Nov 2018 16:58:13 GMT

We have the same problem. Is there a fix for this issue in the next version?

Re: PBIRS error updating/overwriting a PBI report file when "local" characters in folder name

Anonymous — Wed, 27 Mar 2019 09:34:03 GMT

The problem still exists in January 2019 release - I opened an "idea" for bugfixing it:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37210903-bug-fix-error-when-trying-to-save-a-report-with-u