I recently wanted to use the Wall Street Journal exchange rate page to pull the rates into my Excel data model. I hadn't needed this for a couple of years but it's time again to convert currencies.
They seem to have changed the format - my old query broke as it was unable to pull the table. This works in PowerBI but Excel can't seem to read it (Office 365 64-bit v2002)
Searching on Google led to this page, which in turn led to a 2017 post by Gil Raviv.
But manually diving into HTML tags and determining their <div> position is ridiculous... if more websites are moving to displaying tables this way, is there some more recent improvement to Power Query that copes with this method of display?
They seem to have changed the format - my old query broke as it was unable to pull the table. This works in PowerBI but Excel can't seem to read it (Office 365 64-bit v2002)
Searching on Google led to this page, which in turn led to a 2017 post by Gil Raviv.
But manually diving into HTML tags and determining their <div> position is ridiculous... if more websites are moving to displaying tables this way, is there some more recent improvement to Power Query that copes with this method of display?
