Dec 26, 2022
How to deal with null in Power Query
One of the common Data Preparation questions Power BI and Excel Users ask is how to deal with null in Power Query. Do you delete them or replace them with zero? There isRead More
Data Cleaning
Jul 15, 2021
How to use Native SQL Queries on Excel Data with Power Query
Using native SQL Queries against data sources can come with certain advantages. Chief among those advantages is the ability to push data transformation tasks to the data source level, rather than on PowerRead More
