New laptops with ARM processors (such as some Surface models) run older software through an emulation layer, which can cause Power Query to crash. Installing the native ARM64 version of Office allows ...

Every data engineering team right now is being asked the same question: "How do we build a chatbot that talks to our data?" The prototypes are deceptively simple. A developer connects GPT-5.1 to a ...

Perhaps you created a dataflow but then had difficulty getting data from it (either by using Power Query in Power BI Desktop or from other dataflows). This article explains some of the most common ...

We encourage Power Platform dataflow users to migrate from standard V1 dataflows to standard V2 dataflows. Standard V1 dataflows were discontinued on May 31, 2025. As of this date, all standard V1 ...

When using the Web.Contents function to call a web service in Power Query in either Power BI or Excel you may encounter the following error: DataFormat.Error: Block length does not match with its ...

Over the last few weeks, we have released lots of new Power Query & Dataflows features in Power Apps, enabling users to seamlessly bring their data into the Common Data Service – Here’s a recap of all ...

The January 2017 JofA article “Data Mining Your General Ledger With Excel” presents a step-by-step, formula-based approach to extracting general ledger data and then scrubbing them so that they can be ...

In Excel 2016, Power Query is no longer an Excel add-in but a native feature of Excel, and what’s more, you can now use VBA to create and manage Power Query queries. I’ve found two sources of ...