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
ScottStauffer's avatar
ScottStauffer
Icon for Advocate I rankAdvocate I
1 year ago

I have the exact same situation.
A Paginated Report is set up with drill through to another report. In the Power BI Service, the drill through works just fine...

When I take the calling paginate report and export to Excel, I click on the hyperlink in excel, it opens my default web browser and it results in the exact same error message (okay, the timeStamp and the RootActivityId [the GUID] is different!) :


{ "code": "InternalError", "subCode": 0, "message": "An internal error occurred.", "timeStamp": "[Execution Time]", "httpStatusCode": 500, "hresult": -2147467259, "details": [ { "code": "RootActivityId", "message": "[GUID]" }, { "code": "Param1", "message": "powerBIClusterFQDN must be provided." } ] }

The URL copied from Excel looks like this: I've removed the GUID from the URL and added some line breaks for readability...

https://pbipcanc2-canadacentral.pbidedicated.windows.net/webapi/capacities/
{GUID}/
workloads/RsRdlEngine/rs/automatic?
%2F&Param_Name_20_KeyColumn=140
&rs%3AParameterLanguage=

Completed Ideas