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

Question

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.

ritaf1983 · Answer

Hi&nbsp;Bhavyasree24&nbsp;
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-in-power-bipower-query-m/
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
&nbsp;

bhavyasree24 · Answer

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

Forum Discussion

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

2 Replies

Related content

DATESYTD function

function behavior

DAX Studio space after function name

alternative to lookupvalue function

function enable staging