Posted inMicrosoft 365 apps

MC1508229: Microsoft Excel Retires Legacy Get Data from Web and Moves to Modern Power Query Experience

3 minutesPosted inMicrosoft 365 apps
MWPRO IMPACT SCORE
OPERATIONAL IMPACT
51
0 25 50 75 100
HIGH IMPACT • REVIEW RECOMMENDED
Recommended Action:
Review the update and plan any required actions before rollout.
▶ What is MWPro Impact Score? Watch our 60‑second explainer

Primary Audience

Microsoft 365 AdminsIT ManagersService OwnersEnd Users
Why this score?
AI Confidence
HIGH
Enough detail is available to trust this assessment.
Assessment Reasoning
Microsoft is deprecating the ability to create or edit legacy web queries in Excel, with rollout planned for early 2027. Existing legacy queries will continue to refresh, so immediate disruption is low. Admins should plan documentation updates and migration to the new Get Data from Web experience before rollout. Impact centres on Excel data connections, Power Query functionality, and user training rather than service downtime.
60
🛡️ Admin Impact
HIGH
40
👥 User Impact
MEDIUM
45
⚡ Urgency
MEDIUM
50
🔧 Effort
HIGH
ℹ️ WHAT YOU NEED TO KNOW
📌

AT A GLANCE

Excel is moving away from the old Get Data from Web (Legacy) feature. The newer version includes better authentication, detection and refresh options.
👥

END USERS

Users won’t be able to create or edit legacy web queries but existing ones will still refresh.
🛡️

IT ADMINS

Update any training and documentation, and consider migrating queries to the newer Get Data from Web experience.
📅

ROLLOUT TIMELINE

Upcoming:
Mid-January 2027

📢 Official Microsoft Message Center Announcement

Microsoft Excel: Changes to Get Data from Web (Legacy) experience
Message ID: MC1508229

[What and Why:]

To import data from the web with Power Query, use the newer Get Data from Web experience. The existing Get Data from Web (Legacy) functionality will be reduced. The newer experience provides modern authentication, table detection, data transformation, and refresh capabilities.

Existing queries that use the legacy experience will continue to refresh.

[Rollout Schedule:]

General Availability (Worldwide, GCC, GCC High, DoD): We will begin rolling out in mid-January 2027 and expect to complete by early April 2027.

[Impact on Your Organization:]

After this change:

  • Users will no longer be able to create new legacy web queries with the dialog accessed through Get Data > Legacy Wizards > From Web (Legacy) or edit existing ones.
  • Existing legacy web queries in workbooks will continue to refresh, and users can continue to edit refresh properties through Queries & Connections > Properties > Refresh control UI.
  • Programmatic attempts to open the legacy New Web Query dialog will return an error.
  • Programmatic attempts to create legacy Web Query connections will continue to work.
  • Creating legacy Web Query connections through an .iqy file will continue to work.
  • Other legacy data import wizards are not affected by this change.

[Action Required/Recommendations:]

You may want to update internal training and documentation because users will receive this change automatically as it progresses through deployment rings.

Consider migrating web queries to the newer Get Data from Web experience:

  1. Right-click the section of imported data that you want to migrate.
  2. Select Edit query.
  3. Copy the URL from the address bar.
  4. From the Data tab, select From Web in the Get & Transform Data section.
  5. Paste the URL into the address bar and follow the steps to create the new web query.

[Compliance considerations:]

No compliance considerations identified. Review as appropriate for your organization.

Source: Microsoft Message Center • Analysed by MWPro

Share This Update
Tags: