Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
80
Views
Topic starter
Hi i have problem exporting to web query similar view of what u have presented. after insert html link, i dont have choice to select the table /data i want to display. And it ended up importing everything into "sheet "
my steps:
data > from web> https://markets.ft.com/data/league-tables/tables-and-trends/Bonds>import> output=
Posted : 30/05/2017 7:56 pm
Hi Lin,
Did you use the Power Query from web, or the Get External Data > From Web option? I suspect you used the latter. If you're using Excel 2016 then please make sure you use the From web button in the 'Get & Transform' group of buttons.
Mynda
Posted : 31/05/2017 12:22 am