When loading data into an Excel Table using PowerQuery, the Table columns may automatically resize each time the query is refreshed. This can affect the
Author: 1997ismail.hosen@gmail.com
3 Techniques for Character Validation in VBA
In VBA we need to check if a character is valid or not. So, let me give some examples: 1️⃣ File Name
Win and MAC Compatible File Selector
Recently I have found one post on File Selector for windows to use in power query. I would suggest you to checkout
Case Insensitive Text.Replace In Power Query.
By default Text.Replace do case sensitive replacing. Sometimes we need to do case-insensitive replacement. I have created a custom function that will
Secret Power Of Web.Contents PQ Function: Options[Content] Parameter – Part 5
I am sure you have rarely used this or know about this. Yes, You can use the POST HTTP method using Web.Contents.
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
Update VBA Code From Github(Single Code Source).
I had one idea for long time that how can we store all the utility code into one single place(Need to be
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