Excel is a powerhouse at transforming and manipulating data, thanks to a wide variety of Excel formulas and in-app tools. Add Power Query to this already powerful mix, and you get an even more ...

The error code 0x80040e4e occurs if there is a conflict between the data type of the columns autodetected in PowerBI. Manually changing the data type and deleting the ...

The automation of repetitive tasks has become part of today’s workplace, whether CPAs are engaged in industry, governmental, not-forprofit, or public accounting. This automation can consist of ...

Microsoft Power Query requires less specialized knowledge when trying to find duplicate records in a Microsoft Excel sheet. There are several ways to find duplicates in a Microsoft Excel sheet. You ...

Highlighting or even deleting duplicate records in Excel is simple but listing them isn’t as easy. Fortunately, you can use Power Query to easily display a list of duplicate values or records. Whether ...

A long time ago someone – probably from the Power Query dev team – told me that adding primary keys to M tables could improve the performance of certain transformations in Power BI and Excel Power ...

[This blog post is relevant to Power Query in Excel 2010/2013, the Get & Transform section on the Data tab in Excel 2016, and the Get Data screen in Power BI Desktop. I’m going to use the term ‘Power ...