While using FetchXml Query and Power BI the link feature is producing an error

[KFAllegion]

While using FetchXml Query for Power BI when a URL for the record is added the results in Power BI produce an error while the remaining field display data.
Here is the fetch for the URL:
#"Added Link" = Table.AddColumn(#"Changed Type", "Link", each Dyn365CEBaseURL & "/main.aspx?etn=hsl_customervisit&pagetype=entityrecord&id=%7b"& [hsl_customervisitid]&"%7d"),

• Deployment: Online
• DB Version: 9.2.24041.216
• Connection Controls Version: 1.2023.6.56
• XrmToolBox Version: 1.2023.12.68
• Tool Version: 1.2019.423.8

[partridgetim]

It might be that the hsl_customervisit is an activity type table. If that's the case, you need to replace "hsl_customervisitid" with "activityid".