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 SSRS and PowerBi.
The issue is that once the PowerBi report is exported to Excel, when the hyperlink is clicked to launch the sub-report it generates the below error in the web browser. The same process for the SSRS report works fine.
The sub report exists in the same Workspace.
Can anyone offer any help on how to resolve this?
{
"code": "InternalError",
"subCode": 0,
"message": "An internal error occurred.",
"timeStamp": "2023-12-15T10:19:52.0572884Z",
"httpStatusCode": 500,
"hresult": -2147467259,
"details": [
{
"code": "RootActivityId",
"message": "3f49c726-6e3e-47f6-8521-13f56f16a0bc"
},
{
"code": "Param1",
"message": "powerBIClusterFQDN must be provided."
}
]
}
Thanks
Nick
4 Comments
Hi Anonymous ,
Please check your data source and connection and ake sure the data source is accessible and the connection credentials are correct.
You may also inspect your report setup and look for any direct references to a column name or other elements that might not exist in the query.Best regards.
Community Support Team_ CaitlynHi,
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.
- ScottStauffer
Advocate I
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= - Ayone has solution for this
