Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.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
Solved! Go to Solution.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |