Loading Power Query data to Python in Excel Web: Retirement

🚨 The Signal: Microsoft is removing the ability to load Power Query data into Python in Excel for the web by October 2026. This impacts data analysis workflows in the browser, requiring a shift to desktop Excel for this specific functionality.

The Impact

Users leveraging Power Query with Python in Excel for the web are affected, with no direct security risk but potential data workflow disruption.

• Web Excel users: Cannot combine Power Query and Python for data analysis.
• Data analysts: Must use desktop Excel for specific Power Query/Python workflows.
• Business units: Workflows dependent on web-based integration will break.
• IT teams: May need to assist users with desktop Excel transitions.

The Action

1. Identify users and business processes that rely on Power Query data being loaded into Python in Excel for the web.
2. Notify affected users of the retirement and expected workflow impact.
3. Review affected solutions and consider transitioning those workflows to Excel for Windows desktop.
4. Update internal training materials and documentation to reflect the change.

Domain: M365-Apps · Impact: low · Workload: M365 Apps