By default Text.Replace do case sensitive replacing. Sometimes we need to do case-insensitive replacement. I have created a custom function that will
Category: Power Query
Secret Power Of Web.Contents PQ Function: Options[Headers] Parameter – Part 4
This post is about the third most important parameter and that is Headers. We can pass data to a HTTP Call and
Secret Power Of Web.Contents PQ Function: Options[Query] Parameter – Part 3
This post is the center point of Web.Contents PQ Function. Please learn it well. In this post, I am going to introduce
Secret Power Of Web.Contents PQ Function: URL Parameter – Part 2
If you haven’t checked the different parameters of Web.Contents function, then please check them from MSDN. In this post, we are going
Secret Power Of Web.Contents PQ Function: Helper function – Part 1
I wish I knew all of this or could find one place to learn everything about Web.Contents power query function. I used
Replace Space From Power Query Step Name Using VBA
In this blog post, I will show you how to replace space from the Power Query step name using VBA. This can
