cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Muda Visitor
Visitor

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 :

PBI Post.png

 

So behind the word "Google" I have the hyperlink pointing on http://www.google.com/

 

I am trying to find a way to get that hyperlink in a new column in Power Querry.

 

Do you guys have any clue on this ?

 

Thanks in advance,


Muda

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to extract hypertext link from a cell

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

 

https://superuser.com/questions/593492/can-i-use-an-excel-formula-to-extract-the-link-location-of-a-...

 

Regards,

 

Mfelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




1 REPLY 1
Super User
Super User

Re: How to extract hypertext link from a cell

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

 

https://superuser.com/questions/593492/can-i-use-an-excel-formula-to-extract-the-link-location-of-a-...

 

Regards,

 

Mfelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!