Report Server + URL length 260 characters

sevenhills · ‎07-27-2020

Hi,

Power BI Report server (on-premise, local network)

I am getting this error

The path of the item 'https://nnnpbirsdev.mycompany.com:447/ReportServer/BI_HOME/BU100/Reports/Testsv' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: The path of the item 'https://nnnpbirsdev.mycompany.com:447/ReportServer/BI_HOME/BU100/Reports/Testsv' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash.

I already checked these 2018 threads

- https://community.powerbi.com/t5/Report-Server/Power-BI-SSRS-2016-server-not-enter-into-SSRS-URL/m-p...

- https://community.powerbi.com/t5/Report-Server/Power-BI-Report-Server-invalid-url-request-oversized-...

Any idea how to resolve this?

Thanks

d_gosbell · ‎07-28-2020

So the key error here is that the path is not valid. The 260 character limit does not appy here as your entire url is only 79 characters.

The first issue I can see is that this does not look like a properly formed ReportServer url. If you are trying to open a report called Testsv in the /BI_HOME/BU100/Reports folder then it should look something like the following where you pass the path to the report after a question mark.

https://nnnpbirsdev.mycompany.com:447/ReportServer?/BI_HOME/BU100/Reports/Testsv

sevenhills · ‎07-29-2020

Yes, you are right, 260 character limit is not applied to my situation

Related to Path, it is valid. You can try to do these steps to reproduce...

Configure PBIRS https to different port than 443 i.e., 447 in my case
Create the report and place it in two or three level depth of folders like "/BI_HOME/BU100/Reports"
Using the browser, right click the report and try to edit using report builder
You get the error.

Please note:

Sometimes the report opens in report builder but CANNOT run in the report builder.
Sometimes you cannot open the same report in report buidler.

Consistently same errors, same behavior.

thanks