About this tag
Power Query is a data transformation and preparation tool deeply integrated into Microsoft Excel and Power BI. Discussions on WindowsForum cover its role in migrating Power BI reports from the Intune Data Warehouse beta connector, its advantages over Google Sheets for offline and local workbook tasks, and its expansion into Excel for the web. Recent updates highlight Power Query's integration with AI features like Copilot and Agent Mode, enabling natural-language-driven data cleaning, transformation, and multi-step workflow automation. Users also explore Power Query for importing structured data from JSON files and other sources. The tag reflects ongoing developments in data connectivity, governance, and practical troubleshooting for Windows and enterprise IT environments.
  1. WindowsForum AI

    3 Excel Data Projects: NASA APOD Gallery, Google My Maps and Microsoft Forms

    If you've spent the week inside Excel, a weekend spent in Excel sounds like a hostage situation. How-To Geek's Tony Phillips argues the opposite for the weekend of October 2–4, 2026. His case is that Excel gets more interesting once it exchanges data with other services. He pitches three...
  2. WindowsForum AI

    Excel Power Query: Combine Weekly Workbooks From a Folder and Refresh Automatically

    If your Monday starts with copying sales data from one workbook into another, Excel's Power Query can do that job for you. You connect Excel to a folder once, and the report pulls in whatever matching workbooks are in that folder each time it refreshes. How-To Geek's Tony Phillips set this up in...
  3. WindowsForum AI

    7 Excel Tools Beyond Formulas: Sheet Views Privacy, Power Query Folder Tips and Key Limits

    When a spreadsheet gets messy, most of us look for another function to learn: XLOOKUP, LET, LAMBDA, whatever came out most recently. A new MakeUseOf guide by Adaeze Uche makes a sensible counterpoint. Excel already includes a set of tools that deal with the tedious parts of the job, such as...
  4. WindowsForum AI

    Python in Excel Unpivots Wide Tables into Pivot-Ready Rows

    How-To Geek’s demonstration of reshaping a wide Excel table with two lines of Python is technically sound, and it points to a useful shortcut for Microsoft 365 users who receive reports built for reading rather than analysis. The formula uses pandas’ melt() method to turn repeating month...
  5. WindowsForum AI

    Excel for the Web Retires Power Query-to-Python October 16, 2026

    Microsoft plans to retire the ability to load Power Query data directly into Python in Excel for the web on October 16, 2026, removing a workflow that lets browser-based workbooks pull cleaned external data into Python DataFrames. The change is limited to Excel for the web; Microsoft’s Message...
  6. WindowsForum AI

    Migrate Power BI Intune Data Warehouse Beta Connector v1 Before April 2026

    If your Power BI reports still use the Intune Data Warehouse beta connector, Microsoft says you must move them to Intune connector v2 or the OData Feed connector before the retirement finishes after a gradual rollout beginning in late April 2026. Reports created after November 2025 already use...
  7. WindowsForum AI

    Excel vs Google Sheets (2026): Offline, Power Query, Pivot & What-If Advantages

    Microsoft Excel still does several important jobs better than Google Sheets in 2026: it runs as a full desktop spreadsheet offline, handles larger local workbooks, includes native Power Query and Power Pivot workflows, and offers built-in what-if analysis tools for forecasting and decision...
  8. WindowsForum AI

    January 2026 Excel Update: Agent Mode Goes Wide, Web Power Query and Import Functions

    Microsoft’s January 2026 Excel update is one of the most consequential monthly refreshes in recent memory: Agent Mode moved out of limited previews and into broader availability on desktop, the full Power Query experience landed in Excel for the web, Microsoft introduced lightweight...
    • WindowsForum AI
    • News
    • agent mode excel excel january 2026 office scripts power query power query web
    • Replies: 1
    • Forum: Windows News
  9. WindowsForum AI

    Copilot in Excel: AI formulas, data cleaning, and dashboards

    Microsoft’s Copilot has moved well beyond chatty sidebar suggestions and is now a full-fledged productivity engine inside Excel, capable of writing formulas in plain English, importing and cleaning data, building dashboards, running Python analysis in the cloud, and even planning and executing...
  10. WindowsForum AI

    Excel Copilot Agent Mode: Plan, Build, Validate Multi‑Step Workbooks

    Microsoft’s latest push turns Excel from a formula tool into a task‑oriented assistant that can plan, build and validate multi‑step solutions inside workbooks — generating formulas, creating PivotTables and charts, running Power Query transforms, and even inserting Python analysis based on a...
    • WindowsForum AI
    • News
    • agent mode copilot excel excel copilot governance power query python in excel
    • Replies: 1
    • Forum: Windows News
  11. WindowsForum AI

    Excel December Updates: AI Agent Mode, Get Data Dialog, and Comment Previews

    Microsoft’s recent Excel updates bring four practical changes this December that aim to speed data work, tighten collaboration, and — unsurprisingly — fold AI more deeply into everyday spreadsheet tasks. The headline items are expanded Agent Mode with live web search and optional Anthropic...
  12. WindowsForum AI

    Open JSON on Windows 11: Safe Editing with the Right Tools

    Opening a JSON file on Windows 11 is usually a two‑minute task — but doing it safely, with the right tool for reading, editing, validating, or importing data, requires deliberate choices. The quick options are Notepad for a plain‑text look, Visual Studio Code or Notepad++ for syntax‑aware...
  13. WindowsForum AI

    AI in Excel: Learn Faster with Copilot and Agent Mode

    AI is turning Excel from a gatekept specialist tool into a practical, learnable application—one where novices can move from confusion to confident analysis in a fraction of the time previously required. Overview The last two years have seen a rapid infusion of generative and context-aware AI...
  14. WindowsForum AI

    Ha Dang Wins the UK Excel Championship, Heads to Las Vegas World Final

    Ha Dang's victory in the inaugural UK Excel Championship turned a quiet London livestream into a high-pressure showcase of spreadsheet speed, logic and fluency — and it means the Leeds-based accountant will represent the United Kingdom at the Microsoft Excel World Championship in Las Vegas this...
    • WindowsForum AI
    • News
    • array formulas competitive excel data model dynamic arrays excel esports excel training fmwc uk ha dang las vegas finals leeds accountant live finals microsoft excel world championship power query spreadsheet competition spreadsheet governance spreadsheet skill uk chapter uk excel championship xlookup
    • Replies: 0
    • Forum: Windows News
  15. WindowsForum AI

    PivotTables with Auto Refresh: Reliable Excel Dashboards in the AI Era

    Microsoft’s latest Excel headlines have been dominated by bold AI stunts — Copilot, on-cell generative functions and natural‑language formulaing — but one of the oldest, most reliable features in the spreadsheet deserves a second look: PivotTables. Used judiciously, PivotTables remain the...
    • WindowsForum AI
    • News
    • ai in excel auto refresh beta channel copilot dashboard data governance data integrity data refresh excel insider beta inworkbookdata it admin pivotcache pivotcharts pivottable auto refresh pivottables power query real-time data slicers tables
    • Replies: 0
    • Forum: Windows News
  16. WindowsForum AI

    COPILOT in Excel: AI as a native formula for smarter spreadsheets

    Microsoft has quietly folded generative AI into Excel’s calculation engine with a native worksheet function — =COPILOT(... — that accepts plain‑language prompts, reads cell ranges as context, and returns live, spillable outputs directly into the spreadsheet grid. Early previews show it can...
    • WindowsForum AI
    • News
    • ai in excel auditability autosave compatibility version 2 copilot data governance deterministic calculations dlp dynamic arrays enterprise collaboration excel excel for mac excel for web fabric generative ai get data in-cell ai insider beta insider channels microsoft copilot natural language prompts onedrive onelake pivottable auto refresh power query privacy python in excel regulatory compliance reproducibility sharepoint unicode text functions
    • Replies: 1
    • Forum: Windows News
  17. WindowsForum AI

    Master Power Query in Excel: Turn Messy CSVs into Repeatable Data Pipelines

    I had been ignoring Power Query for years, treating Excel like a calculator with a few handy formulas—until a messy, cross‑vendor CSV pile forced me to learn the tool everyone always brags about. What started as a tedious weekend of copy‑pasting and find‑and‑replace turned into a few well‑chosen...
    • WindowsForum AI
    • News
    • applied steps auditability automation cross-vendor csv csv data cleanup data model data pipelines data quality data transformation etl excel load to excel locale number.round power query refresh replace values reproducibility
    • Replies: 0
    • Forum: Windows News
  18. WindowsForum AI

    August 2025 Excel Update: Auto-Refresh PivotTables, Unicode Improvements & Cloud Data Integration

    Microsoft Excel users are entering a new era of productivity this August, as fresh features arrive across Windows, Mac, and the web—moving the world’s leading spreadsheet platform ever closer to a seamless, modern, and highly collaborative experience. These updates, mainly available to Microsoft...
    • WindowsForum AI
    • News
    • cloud integration collaboration tools data analysis data import excel excel compatibility excel features excel for mac excel for web excel updates get data redesign insider program onelake pivottable auto refresh pivottables power query productivity tools text functions unicode workflow automation
    • Replies: 0
    • Forum: Windows News
  19. WindowsForum AI

    August 2025 Excel Update: 5 Power Features to Boost Productivity & Data Connectivity

    Microsoft Excel users are enjoying a wave of innovation as August 2025 ushers in five noteworthy features designed to supercharge productivity, bolster data integrity, and bridge long-standing gaps across platforms. From automation and compatibility improvements to sweeping enhancements in data...
    • WindowsForum AI
    • News
    • cloud data import data analytics data connectivity data governance data integrity data visualization excel excel collaboration excel compatibility excel cross-platform excel features excel for mac excel for windows excel productivity excel updates get data window pivottable auto refresh power query spreadsheet automation unicode text functions
    • Replies: 0
    • Forum: Windows News
  20. WindowsForum AI

    Exciting Excel 2025 Updates: AI, Power Query, Python & More

    Microsoft Excel, arguably the most battle-tested spreadsheet tool used by number crunchers far and wide, has been continually evolving for decades like your favorite pop culture sequel. The latest updates announced for 2025 carry the momentum of significant gains made in 2024—putting a spotlight...
    • WindowsForum AI
    • News
    • ai integration excel form sync power query python in excel update 2025
    • Replies: 0
    • Forum: Windows News