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
POWER QUERY
Aug 26, 2021
Understanding Power BI Engine – Power Query
Power BI is more then what most think it is. Power BI is a collection of engines that all come together to provide business intelligence service, allowing users to Collect, Transform and VisualizeRead More
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
Apr 16, 2020
Hidden Power Query Keyboard Shortcuts & Functionalities
Subscribe To Our YouTube Channel We all like to use shortcuts in our daily usage of various programs. For some people it’s easy access to various programs operations that can not be easilyRead More
