Getting hyperlink column from SharePoint List Returns Record

[Portals365]

I using Get Data>Other>SharePoint List to retrieve data from a SharePoint Online in Office365. The list contains a hyperlink column.  When the column populates in PowerBI it returns (Record).  Adjusting the column to Web URL does not help.

Any suggestions?

[Portals365]

Great - this solved the problem.

Thanks

[v-qiuyu-msft]

Hi @Portals365,

As the issue has been solved, would you please mark a helpful reply as an answer so that we can close the thread?

Best Regards,
Qiuyun Yu

[v-qiuyu-msft · Accepted solution]

Hi @Portals365,

As the SharePoint list exists on Office 365 SharePoint Online, I would suggest you use Get Data-> Online Services-> SharePoint Online List data source. Assume the hyperlink column data type is Hyperlink or Picture in the list, when we type the site URL and check the list, the hyperlink column is displayed as a record. We need to open Query Editor, then extract this column get URL value, then change data type as Web URL.

Best Regards,
Qiuyun Yu