Missing hyperlinks when connecting to a Web Data Source

Question

I am trying to Get Data from Web. The data source has hyperlinks that are shown below (highlighted). When I load the data to Excel, the hyperlinks appear as Text that I cannot click. Any ideas on how to load the hyperlinks with the rest of the data? Thanks.

jkpieterse · Answer

Perhaps this thread helps: https://social.technet.microsoft.com/Forums/en-US/f686efea-96ac-482a-827f-428f45ffb68d/use-power-query-to-extract-hyperlinks-from-a-web-table?forum=powerquery

Forum Discussion

Missing hyperlinks when connecting to a Web Data Source

Share

Resources