Anonymous's avatar
Anonymous
Not applicable
2 years ago
Status:
Investigating

Excel Hyperlink generates internal error - 500 powerBIClusterFQDN must be provided

Hi All,   I have recently migrated a paginated SSRS report to PowerBI, by re-ipoading the SSRS RDL file to the service.   The report contains a hyperlink to a sub-report, which runs fine in both ...
Report Server
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

 

Thanks for the reply. I can confirm that the data source are accessible  

 

Both the SSRS and PowerBi reports run fine when viewed within a browser.

 

If the SSRS report is exported to Excel, the hyperlink launches correctly and the URL looks something like this - e.g. http://<servername>/ReportServer?%2FFinance%2FReports%2FAged%20Expenses%20Line%20Breakdown&Job_No=J0054839&rs%3AParameterLanguage=

 

If the PowerBi report is exported to Excel, the hyperlink  generates the error in the browser and the URL looks something like this e.g.

https://AAAA8be8148XXXXd518ecNNNN34b9.pbidedicated.windows.net/webapi/capacities/1F5FC809-2663-4EF5-B46B-A87B79082EB5/workloads/RsRdlEngine/rs/automatic?%2F&Job_No=J0054839&rs%3AParameterLanguage=

 

I have also noticed that if i run the first part of the URL  e.g. https://AAAA8be8148XXXXd518ecNNNN34b9.pbidedicated.windows.net

It returns: HTTP Error 503. The service is unavailable.

 

 

Completed Ideas