Forum Discussion
Getting hyperlink column from SharePoint List Returns Record
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?
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
3 Replies
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 YuGreat - this solved the problem.
Thanks
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? :smileyhappy:
Best Regards,
Qiuyun Yu
