WebBrowserContents does not work

[GeroNikles]

Hello everyone,

i am new to this community. I know there are already threads about this topic, but the solutuion is not working for me or cant be the right solution.

So on my PC for work i use the Excel Version 2406. Everything is fine and Web.BrowserContents works in PowerQuery.

But on my VM i have the problem that Excel is on Version 2407 and Web.BrowserContents shows a empty table in PowerQuery.

Also there is no more the possibility of choosing between different tables on the website.

Of course i can just downgrade my Excel from 2407 to 2406 but thats not a lont time solution.

[Anonymous · Accepted solution]

Hi @GeroNikles ,
Based on your description, I tested it in an uncle 2408, using Web.BrowserContents(“https://microsoft.com”). The result can return html statements. So you can try to upgrade excel to a higher version, please note if you need to save authentication and set the credentials. According to the documentation, the use of web.browsercontents requires the use of the webview 2 component, when you run this function in excel, you can open the task manager to see if the component is running. Of course, you can also use this function in power bi desktop, the webview 2 component is included in the power bi dessktop itself.

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[GeroNikles]

Hey, thanks for your message.
On power BI Desktop is everthing working as expected. I will try it later on Excel with the Version 2408 and give you Feedback.

[GeroNikles]

I forgot one thing. On the VM I installed the latets Version of Power Automate Desktop today. And on my PC for work not, beacuse i am not an admin there