Excel From Web power query defaulting to Web.BrowserContents instead of web.page(web.contents())

[ankhtuja]

My excel used to open 'from web' as web.page(web.contents()) but suddenly is defaulting to Web.BrowserContents instead. Now I cant detect my tables, and only see an HTML script. My old queries how show 'open files as 'html page (legacy)'. 

Is there a setting or something I can do to make sure I can see/detect my tables normally and continue to use web.page(web.contents)) instead of having to manually type it out in 'advanced editor M-code'? 

[v-pagayam-msft]

Hi @ankhtuja ,
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.If Yes, consider Accept it as a solution to help the other members find it more quickly.

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @ankhtuja ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you for your cooperation. Have a great day.

[v-pagayam-msft]

Hi @ankhtuja ,
Thank you @Akash_Varuna  for the accurate response that help to resolve the issue.
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you as accept as solution. It would be greatly appreciated by others in the community who may have the same question.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

Regards,
Pallavi.

[Akash_Varuna]

Hi @ankhtuja , Could you try this

• In Power Query Editor, go to File > Options and Settings > Query Options.
• Under Global > Data Load, ensure Legacy web view is enabled.
  You can also adjust queries in the Advanced Editor to use Web.Page(Web.Contents()).
  If this post helped please do give a kudos and accept this as a solution
  Thanks In Advance