Microsoft will retire Power Query support for Python in Excel for the web on October 16, 2026, potentially breaking existing workflows.
Chris Webb shared a two part article on optimizing the performance of Power Query merges. Known as joining in SQL, merging in Power Query can result in performance issues when refreshing. Using a CSV ...
Chris Webb shared his thoughts on a new Power Query feature released in December for Power BI Desktop. The InferSheetDimensions Excel.Workbook function can infer the value for certain cells from the ...