Data Cleaning

Homepage › Posts Tagged "Data Cleaning"

December 26, 2022

How to deal with null in Power Query

POWER QUERY 18765 Views

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 is no

July 15, 2021

How to use Native SQL Queries on Excel Data with Power Query

MICROSOFT EXCEL, MICROSOFT POWER BI, POWER QUERY 6035 Views

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 Power Query

Data Cleaning

How to deal with null in Power Query

How to use Native SQL Queries on Excel Data with Power Query

Company

Consulting

Resources