Any alternate function is there for GETLINK Function in Google sheets and Power BI?

[Bhavyasree24]

I have one requirement like i have to extract the hyperlinks from the text column in Google sheet so using GETLINK with Appscript i have extracted the links and imported that file into Power BI. After Development when i do manual refresh it worked and added Auto refresh then it throws error like Unknown GETLINK Function. So is there any alternate Function which will work in both Google sheet and Power BI.

[Bhavyasree24]

Thanks for you reply , but i have to extract the hyperlinks in google sheet only .

[Ritaf1983]

Hi @Bhavyasree24 

Take a look at the linked article, maybe it can help.

https://blog.crossjoin.co.uk/2017/04/25/using-text-betweendelimiters-to-extract-urls-from-a-web-page...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly