Power Query does not return a table

hasanlianar

New Member
Joined
Jul 21, 2011
Messages
43
Hello,

I want to get the table containing currency rates from the following web site: www.cbar.az/currency/rates
Though Power Query does not return a table, but HTML parts.
Is there a way to get the table from the mentioned web site?

Best,
AH
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
6,717
but you can get data from xml or excel file
copy link to xml and import to the PQ
 

Watch MrExcel Video

Forum statistics

Threads
1,108,810
Messages
5,525,010
Members
409,615
Latest member
papaluigi94

This Week's Hot Topics

Top