Issues trying to create a hyperlink in a table

[Daves902]

I would like to add a hyperlink to a table in BI that allows the viewer to click through to a live record in Salesforce (opportunity).

I have created a formula text field on the opportunity layout that captures the URL, "https://eu?.salesforce.com/" & Id which works fine in a SF report. 

However, when it pulls through to BI it contains HTML tags which render it useless, <a href="https://eu?.salesforce.com/006D000000?????" target="_blank">Link</a>

I have tried updating in the Modelling tab but I think the issue is prior to that.  Any help would be greatly appreciated.  Thank you, Dave

<a href="https://eu?.salesforce.com/006D000000?????" target="_blank">Link</a>