topic Re: Export paginated report to excel with hyperlink and large amount of records in Report Server

Export paginated report to excel with hyperlink and large amount of records

cascador — Thu, 11 Jul 2024 06:40:13 GMT

Hello everyone

since the last (second release) update of power bi report server (may 2024), and after the issue with image solved (see https://community.fabric.microsoft.com/t5/Report-Server/Export-paginated-report-to-excel-with-image/m-p/3996645) we are facing another anoying issue.

after exporting excel (with a large amount of record or excel size) we have another kind of error:

the same report with a parameter that returns less records is correctly exported, and hyperlink are working.

but with a parameter which returns a lot of records (about 40 k), we got the above message

report is composed of a simple tablix, with some cells containing hyperlink

in browser view, all works fine, and hyperlink are working.

but after exporting to excel, it "crash"

Any suggestions on how to get around this.

regards,

Re: Export paginated report to excel with hyperlink and large amount of records

d_gosbell — Thu, 11 Jul 2024 11:04:27 GMT

My guess would be that it's not the number of records that is the issue, but rather that something in that dataset is somehow producing an invalid hyperlink. I'd suggest trying to test the first half then the second half and see if one works and not the other. Then keep halving the dataset until you get down to a reasonable number of records and can look for potential problems (eg. < > characters in the hyperlinks or something like that)

Re: Export paginated report to excel with hyperlink and large amount of records

cascador — Fri, 12 Jul 2024 06:02:17 GMT

Dear d_gosbell

thank you for quick answer. That's one think I've check, but url link set on the action parameter is set like this

= "https://xxxx.yyy/mypage.aspx?id=" + value of id.

all id have the same pattern, and what is strange, is that I use the same link in a picture. and removing all hyperlink Action except the one on picture, the report is correctly exported..

regards

Re: Export paginated report to excel with hyperlink and large amount of records

d_gosbell — Fri, 12 Jul 2024 06:23:41 GMT

If you are sure that all the hyperlinks are valid then you might need to raise a support ticket with Microsoft.