Hyperlink in table comes through as text

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.