Forum Discussion
Power query uses old Internet explorer
I need to download data into Excel from a web site that uses javascript.
But Power Query in Excel is using Internet Explorer ver 11 that cannot open this site.
I found information that Internet Explorer is not supported now, and it is recommended to use Edge browser.
Excel version is 2301 (16026.20146, 32-bit)
Power Query version is 2.112.523.0, 32-bit
I think they are the latest one.
Also tryed in my friend's office 365, and there is the same problem.
His excel version is 2204 (15128.20264, 64-bit)
Power Query version is 2.104.381.0 (64-bit)
How to make Power Query in Excel to use Edge or Chrome instead of Internet Explorer?
I see, if in order to import your table directly, you need javascript, then I think (not 100% - others can correct me) there is no easy option except the builtin Internet Explorer.
----
P.S.:
BUT 😊 I think there is a HIGH probability that the webpage gets the data necessary to build your table via a separate server request (json, xml etc). If this is the case, then instead of connecting to the webpage you could make the same request as the webpage and ingest the data directly in json... (bypassing the problematic javascript).
It's not easy for me to explain how you could confirm if there is a separate server request - it would be like this:
- open your webpage in your favourite browser
- press F12 to open developer tools
- go to the network tab
- press F5 to reload the page and see the network activity
- click on each of the requests you see in the network tab and look in the Response tab to see if you find there a json or something with your data
If you're lucky to find your data there in json etc., then we might be able to help you extract it in a separate question.
It's a LONG shot (!), but if you really NEED that data into Power Query to make your professional life a lot better, I think it's worth a shot.
4 Replies
Hi,
Don't think that you can change "wev engine" (NOTE I'm NOT an expert here), but let me guess: javascript in the website is doing auth redirection, right?
No, there is no auth redirection.
In HTML code there is link to javascript that needs to be executed in my computer.
And Chrome does so, but internet explorer doesn't - like power query.
I see, if in order to import your table directly, you need javascript, then I think (not 100% - others can correct me) there is no easy option except the builtin Internet Explorer.
----
P.S.:
BUT 😊 I think there is a HIGH probability that the webpage gets the data necessary to build your table via a separate server request (json, xml etc). If this is the case, then instead of connecting to the webpage you could make the same request as the webpage and ingest the data directly in json... (bypassing the problematic javascript).
It's not easy for me to explain how you could confirm if there is a separate server request - it would be like this:
- open your webpage in your favourite browser
- press F12 to open developer tools
- go to the network tab
- press F5 to reload the page and see the network activity
- click on each of the requests you see in the network tab and look in the Response tab to see if you find there a json or something with your data
If you're lucky to find your data there in json etc., then we might be able to help you extract it in a separate question.
It's a LONG shot (!), but if you really NEED that data into Power Query to make your professional life a lot better, I think it's worth a shot.
That helped. Thank you a lot!
