Forum Discussion
Power query uses old 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.
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!