Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Importing links from excel

Hi ,   Need urgent help!   I have a table in excel as below, where the id's have hyperlink associated to it.   ID 1111 1222   I want to import this column in power bi, with the li...
Need Help
  • affan's avatar
    affan
    7 years ago

    Hi Anonymous

     

    You can extract the URLs in the excel file and then import the excel data into power bi.

     

     

     

     

     In excel you can insert the following in a new module and use it as a funciton as illustrated above.

     

    Function CopyURL(HyperlinkCell As Range)

CopyURL = HyperlinkCell.Hyperlinks(1).Address
End Function

     

    If this helped you, please mark this post as an accepted solution and like to give KUDOS .

     

    Regards,

    Affan

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you for this solution.

How could I allow the function to ignore the IDs without hyperlink and return a blank cell instead of an error? 

Best,

IV