Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Fabric Community site will be in read-only mode on Monday, Feb 24 from 12:01 AM to 8 AM PST for scheduled upgrades.

Reply
ankhtuja
New Member

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

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'? 

3 REPLIES 3
v-pagayam-msft
Community Support
Community Support

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
Community Support
Community Support

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
Responsive Resident
Responsive Resident

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors