Antriksh SharmaSep 3, 20211 min readHow To Load Data In Power BI With Stored Procedure and ParametersIn 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 SharmaJul 1, 20212 min readDynamically Remove Null Columns in Power Query with M codeI 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 SharmaJun 17, 20211 min readDynamically change column names in Power Query using predefined valuesIn 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 SharmaMay 3, 20211 min readClean a string using M in Power QueryIn 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...