topic Re: Report Server + URL length 260 characters in Report Server

Report Server + URL length 260 characters

sevenhills — Mon, 27 Jul 2020 18:00:35 GMT

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/379997

- https://community.powerbi.com/t5/Report-Server/Power-BI-Report-Server-invalid-url-request-oversized-length-of/m-p/367988

Any idea how to resolve this?

Thanks

Re: Report Server + URL length 260 characters

d_gosbell — Wed, 29 Jul 2020 04:41:20 GMT

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

Re: Report Server + URL length 260 characters

sevenhills — Fri, 31 Jul 2020 16:11:35 GMT

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

Re: Report Server + URL length 260 characters

sevenhills — Thu, 06 Aug 2020 21:25:35 GMT

I am not seeing any responses ...

Did anyone has configured PBIRS for

"https + using custom port"

i.e., different port other than 443 and tried the ReportBuilder?

Any input for fixing this is appreciated 🙂

Regards

Re: Report Server + URL length 260 characters

sevenhills — Fri, 04 Sep 2020 20:47:16 GMT

Those who have the same error, vote this, using link

https://feedback.azure.com/forums/908035-sql-server/suggestions/40649680-ssrs-unable-to-launch-specific-report-in-report-b

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/936bd9e6-0605-40cb-8e9e-3310370d0b6b/bug-in-report-builder-30?forum=sqlreportingservices