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

affan's avatar
affan
Solution Sage
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