Connecting sharepoint list to PowerBI - hyperlink column type

[Frode1000]

Hey

I have a sharepoint list that has hyperlinks, these field use both the hyperlink and the alternative text fields. 

Can i get both of these into power bi? Currently i only get the url itself.

thanks!

[Sahir_Maharaj · Accepted solution]

Hello @Frode1000,

Here's how you might adjust the M code in the Advanced Editor to extract both pieces of information:

let
    Source = SharePoint.Tables("https://yoursharepointsite", [ApiVersion = 15]),
    YourList = Source{[Id="YourListID"]}[Items],
    
    ExpandedHyperlink = Table.TransformColumns(YourList, {"YourHyperlinkColumn", each {Record.Field(_, "Url"), Record.Field(_, "Description")}, {"URL", "Description"}})
in
    ExpandedHyperlink