Hyperlink in table comes through as text

[Will85]

I am connecting to a table via OData, one of the columns contains hyperlinks. I am currently loading this table into Excel, and each cell within that column does not come through as a hyperlink. I have to click each cell press enter before excel recognizes it as a hyperlink turns the link blue and the link becomes active and clickable.

Is there a way to format the column so that it always sees the link as a link without having to click it.

Dows PowerBI offer this functionality? I am new to PowerBI, but loading this table there is an option I can explore as well.

 

[Matt Allington]

you can do this in Power BI but not in Excel that I know of. Maybe you could use VBA to do it for you.