top of page
Power BI | Excel | Python | SQL
Search

Split delimeted text to multiple rows in Power Query
In this blog let's take a look at how to split multiple columns with concatenated strings into rows in PowerQuery, we will write M code...
Antriksh Sharma
Apr 53 min read
159
0

How To Load Data In Power BI With Stored Procedure and Parameters
In this blog let's see how we can combine Stored Procedure and Parameters to load data into PBI. First we need to create a very basic...
Antriksh Sharma
Sep 3, 20211 min read
5,010
0

Dynamically Remove Null Columns in Power Query with M code
I was recently working with a dataset and found that there were a lot of columns that were completely null, now going 1 by 1 through each...
Antriksh Sharma
Jul 1, 20212 min read
5,325
2

Dynamically change column names in Power Query using predefined values
In Power Query if you want to change names of columns you can easily do so by going through each column one by one and then renaming...
Antriksh Sharma
Jun 17, 20211 min read
903
0

Clean a string using M in Power Query
In this blog I am going to show you how you can remove unwanted characters all at once from an improper text string like the following...
Antriksh Sharma
May 3, 20211 min read
259
0
bottom of page