Be among the first 100 to jump on board "The Query Editor" newsletter 🚀. It's packed with super-actionable tips and insights. Why should you be excited? 🌟 Because the first 100 subscribers will receive an exclusive 50% discount on my upcoming mini-course, set to drop early next year (or perhaps even sooner)! 🤞Just hit this link to subscribe thequeryeditor.beehiiv.com/subscribe 🚀🔥
It's funny how often I have used the Keep/Remove rows function in the GUI, but never noticed the option to "Remove alternating rows". I wonder how many other functions are hiding in plain view. Might be an interesting topic for another video if you can find enough of them. I know that it was a few years before I even looked at the "Statistics" icon, and it is useful in certain circumstances.
Today, it z first time, watching your Video… Really your Method is AWX. Plz accelerate the No. of Video base on solid issue regarding Excel and Power BI..
Hi Danish, thank you so much, I'm glad the video was helpful. I will do my best to accelerate the number of videos (I can only do this part time at the moment). Please help with the channel growth by subscribing if you haven't already, watching, liking and commenting on more videos if you find them helpful, thank you for the support!
Hii i am getting error of "external table is not in the expected format" how can I resolve this please help. Also I am using office 2016 version 32 bit .
Hi Mayur, if your files are in .xls, try convert them to .xlsx. You can also check which of your files caused the error if you make a query to folder (Folder.Contents or Folder.Files), filter all xlsx files and then add a custom column with formula Excel.Workbook([Contents]). If a file has the error, this formula will return the error (keep rows with errors), and you can then find all files with problems.
Be among the first 100 to jump on board "The Query Editor" newsletter 🚀. It's packed with super-actionable tips and insights. Why should you be excited? 🌟 Because the first 100 subscribers will receive an exclusive 50% discount on my upcoming mini-course, set to drop early next year (or perhaps even sooner)! 🤞Just hit this link to subscribe thequeryeditor.beehiiv.com/subscribe
🚀🔥
Thanks for including the practice examples worksheet. Makes learning so much better when you can practice what you just watched. Excellent video.
Thank you John, glad it was helpful :)
This channel is like an undiscovered gem
Thank you so much for the kind words!
Love love your video !!!!!!!!!!!!!
You are the best tutor in teaching power query lesson adding proper script
Wow, thanks! I'm so glad you enjoyed the video!
It's always fun to learning something new in power query
Definitely agree!
Can we keep middle row instead of first row. So that we can add top 5row and bottom 5row
It's funny how often I have used the Keep/Remove rows function in the GUI, but never noticed the option to "Remove alternating rows". I wonder how many other functions are hiding in plain view. Might be an interesting topic for another video if you can find enough of them. I know that it was a few years before I even looked at the "Statistics" icon, and it is useful in certain circumstances.
That sounds like an interesting video, thanks for the suggestion! I've added it to my list of video ideas :)
Today, it z first time, watching your Video… Really your Method is AWX. Plz accelerate the No. of Video base on solid issue regarding Excel and Power BI..
Hi Danish, thank you so much, I'm glad the video was helpful. I will do my best to accelerate the number of videos (I can only do this part time at the moment). Please help with the channel growth by subscribing if you haven't already, watching, liking and commenting on more videos if you find them helpful, thank you for the support!
Excellent video. thank you so much👍
Glad you like it Kebin, thank you :)
Thank you so much ❤️
You're most welcome, thank you for your support!
Thank you so much 👌👌👌
You’re welcome dhun!
Hii i am getting error of "external table is not in the expected format" how can I resolve this please help. Also I am using office 2016 version 32 bit .
Hi Mayur, if your files are in .xls, try convert them to .xlsx.
You can also check which of your files caused the error if you make a query to folder (Folder.Contents or Folder.Files), filter all xlsx files and then add a custom column with formula Excel.Workbook([Contents]).
If a file has the error, this formula will return the error (keep rows with errors), and you can then find all files with problems.
@@MissMicrosoft thank you will try it surely