Get Data From Web Browser Incompatibility

[velka]

I've been troubleshooting this for a bit, any help will be apprecciated. 

Trying to get data from Walmart's website for a product to get up to date pricing on items. When using "get preview" the unsupported browser web page displays. To confirm,

-Chrome is supported by them per splash page

-Chrome is set as default program on the device

-PowerBi is set to use the default browser

When using "whatismybrowser.com", it's showing as using the IE agent header which we think is preventing the website/data from being viewed on walmart.com. 

Again, any help would be great. I want to keep this initial post short so this isnt all the troubleshooting done, just the determination. I can provide specific url being used for testing and anything else if needed. Thank you!

[croberts21]

Did you say PBI is using "IE" in the user agent header?

What is the exact string that Power BI is using as the user agent?

And how did you determine what user agent PBI is using? 

[velka]

Hello, hopefully these screenshots help. 

Using whatismybrowser.com is how we determined this, as you can see.

[croberts21]

I have PBI Desktop from May 2022 and I'm getting a lot more tables in the page you posted above. Here's a screenshot. 

When I click on one of the tables to preview it, then click on the "Web view" tab for that table, I get the error "Sorry, Walmart doesn't work with your browser". It's odd. 

So then in PBI I opened a Web data source to http://whatismybrowser.com. And I got this in the Web View tab which says I have IE 11. 

I don't have Windows 10. I have Windows Server 2019 Datacenter but the website thinks I have Windows 10.

Now look what I found here. MS Edge may be using a legacy mode called "IE mode". https://docs.microsoft.com/en-us/deployedge/edge-ie-mode

"We created Internet Explorer (IE) mode in Microsoft Edge for organizations that still need Internet Explorer 11 for backward compatibility with existing websites but also need a modern browser. This feature makes it easier for organizations to use one browser, for legacy web/apps or for a modern web/app. This article provides an introduction to using Microsoft Edge with IE mode."

Further down that page it shows a screenshot of MS Edge which reports a "compatibility mode" of "IE 11". Perhaps PBI is using a compatibility mode for the Walmart site. This article then goes on to talk about what the Edge "IE mode" supports and does not support. 

[velka]

Thank you for the contribution. I did just update PowerBI to the may version, though still no luck (also amount of tables still doesn't match yours). As for the IE 11 on Win10, that is now what is displaying on mine as well. Note, we are using Win10 in our environment, though we currently have all IE requests automatically redirecting to Edge w/ compatability mode enabled if necessary. I did go into the developer tools and disable compatability mode entirely in Edge however the results are the same. 

Attached screenshot to show updated whatismybrowser.com results. 

As you said, this one issue is very odd. Genuinely, thank you for your time! 

We're currently submitting a ticket directly to the PowerBi reps at Microsoft, as well as continuing in house troubleshooting.

[croberts21]

I think it's time to get MS engineers involved. You can make a post here and put a link to this thread: https://community.powerbi.com/t5/Issues/idb-p/Issues

You can also look for known PBI issues here: https://docs.microsoft.com/en-us/power-bi/troubleshoot/known-issues/power-bi-known-issues

Please bookmark these as they are pretty handy. 

[velka]

Hello, yes I did.

Here is the testing url: https://www.walmart.com/ip/seort/25463384

[mohammedadnant]

Hi @velka 

I tried the link and found it as below, I get the list of tables, but when I click on the web view it says browser not supported... FYI, default browser is Microsoft EDGE

Thanks & Regards,

Mohammed Adnan

[velka]

Hi,

Yes, we got the same result. Even when switching the default browser to either edge/chrome/firefox. Essentially this is the issue as the user wants to be able to scrape only the pricing data but without the web preview, they aren't able to.

Today we tried the same link in Excel's Data pulling feature and it worked there, albeit in a very messy  and non-ideal way. 

[mohammedadnant]

Hi @velka 

did you try by clicking on the below button to add tables using examples..?

can you provide the url to test..?

Thanks & Regards,

Mohammed Adnan

Learn Power BI: https://www.youtube.com/c/taik18