Forum Discussion
Solved
How to extract hypertext link from a cell
Hello everyone, I am trying to extract using Power Querry in Power BI the hypertext link of an excell cell : So behind the word "Google" I have the hyperlink pointing on http://www.goog...
Hi Muda,
As far as I know this is not possible, even in excel you have to use VBA to achieve this, problably you can change you base to have a VBA formula that retrieves thar URL to another cell and then work with that in you Power BI.
Check this link for getting the information to excel and then add it to your data
Regards,
Mfelix
MFelix
Super User
Super UserHi Muda,
As far as I know this is not possible, even in excel you have to use VBA to achieve this, problably you can change you base to have a VBA formula that retrieves thar URL to another cell and then work with that in you Power BI.
Check this link for getting the information to excel and then add it to your data
Regards,
Mfelix