Check out the website here: powerquery.how/. Also, if you're interested in learning the M language, we released the Definitive Guide to Power Query M. You can find it here: geni.us/ODZl8. Enjoy!
@danyos7773 ай бұрын
I always find Microsoft pages messy, unclear, and lacking in logic. I’m glad you’ve built this website on a topic that requires clear and in-depth explanations along with practical examples. Thank you!
@BIGorilla3 ай бұрын
You're very welcome! I agree. It’s still a work in progress, but helpful nonetheless. Enjoy!
@robbe583 ай бұрын
Your website is a masterpiece. Structured very well, clear, and pleasant to read. Just a nice tool when working with Power BI. 👏👏🙏
@BIGorilla2 ай бұрын
Many thanks!
@raimundojs95473 ай бұрын
Too much gratitude for your exceptional, brilliant work! I've never found any other website (free or paid) that much organized and useful about M language. No words to thank you enough!
@BIGorilla3 ай бұрын
Always happy to read your response raimundo. If you ever want to contribute, you know where to find me 😁
@RobertoStaltari3 ай бұрын
I already had this site among my numerous bookmarks, knowing the author, I knew I would find answers to my questions. However, I must admit I had not fully appreciated the quality of the content and its presentation. This video highlights many aspects I had not considered about its proper use. A big thank you to the author.
@BIGorilla3 ай бұрын
I'm glad to hear that, thanks you Roberto. I hope it lives up to the expectations!
@rameshv7385Ай бұрын
Last one month i am searching for good website and KZbin videos for M language. But i didnt get. Today i checked in linkedin . I found your website and i get confident to learn and it was very clear and very easy to understand. Thanks a lot.
@JohnKpl2 ай бұрын
You spoke very mildly about Microsoft's site. Their sites very rarely provide answers. Great peace of work!
@GeertDelmulle3 ай бұрын
This website is really nice: everything is put together so well. Got it bookmarked for reference. :-) Thanks for all the hard work, Rick!
@BIGorilla3 ай бұрын
Thanks for your support Geert!
@ourlittlesmarties118813 күн бұрын
This website is perfect. The layout is easy to navigate. Great resource for all PQ users. Thanks for your hard work, Rick!
@zahoorsarbandi29823 ай бұрын
Of course, this website is 100 times better than Microsoft Power Query pages which is messy, unclear, and lacking in logic
@BIGorilla3 ай бұрын
❤🙏
@CAKimberlyLewis3 ай бұрын
True Fact: If I have a Power Query question now say, "I need to powerquery.how this." instead of "I need to google this." because all my answers and more are in powerquery.how! Thank you for all you do for us!
@BIGorilla2 ай бұрын
That is awesome!!
@erivaldolopes63210 күн бұрын
Best PQ assistant ever. Keep it up Rick. Fan of your job and videos
@gef243 ай бұрын
Your site is in my browser favourite at the expense of the Microsoft one for few weeks. Much clearer, understandable and also easy to navigate.
@BIGorilla3 ай бұрын
❤ appreciate that! Thanks for the compliment
@Bhaskar_Joshi_there3 ай бұрын
My first preference on Power Query
@ftmagicart3 ай бұрын
Thank you very much for sharing your work through this site. I use it very often.
@BIGorilla3 ай бұрын
You do? Excellent! I’m about to give it some more love coming time :)
@KlausEltropАй бұрын
Great work. It deserves an award or at least significantly more success on KZbin traffic
@barttrudeau92373 ай бұрын
Thank you so much for this work you have done, it's a tremendous benefit to the community
@BIGorilla3 ай бұрын
Happy to help!
@mohammed333suliman3 ай бұрын
Thank you so much , you are spending effort and time to make information accessible
@BIGorilla3 ай бұрын
It's my pleasure; there’s so much to learn :)
@baskis693 ай бұрын
I love this website, without a doubt the reference website for M language.
@Blueboy303 ай бұрын
Fantastic. I'm sure it will be a great reference. Microsoft website, I find can be very confusing.
@TheMoh1483 ай бұрын
Hi, Many thanks for your valuable content 1. How to extract time column from date_time column without breaking the query folding? 2. How to change data type from number to integer to optimize the data model without breaking the query folding? Thanks in advance.
@kaizen520713 ай бұрын
Probably the best M language reference I have come across. And I won't even compare this with d official documentation. I have just been using this for a couple of weeks, I have bookmarked this and removed d official documentation from my bookmarks 😂. In any case, I am looking forward to contributing to this resource. Cheers!!
@BIGorilla3 ай бұрын
That’s the biggest compliment! Happy to hear that 👌😋
@adrianoschwenkberg67733 ай бұрын
i bought the printed book to support your work. nice work rick.
@72132613 ай бұрын
Thank you very much Rick, for your tytaneous work. I`m really think that what you`ve done should be at the Microsoft`s users hall of fame!
@BIGorilla3 ай бұрын
Wow, thanks - that’s very kind. Truth is, Microsoft has only so many resources. And their website is used for so many languages. Starting fresh, like me, brings flexibility 😁
@felipesignorellireis78393 ай бұрын
Amazinnnnng 🇧🇷 Love the work. Lot of work.
@BIGorilla3 ай бұрын
Thanks Felipes!
@rodrigochavez73 ай бұрын
Looking forward a Power Query course from you mastering the M language! Thank you for this amazing resource
@BIGorilla3 ай бұрын
Me too Rodrigo. It may take a little while still as I haven’t started , but it’s on the roadmap. 😁
@ramruttunaubeeluck92353 ай бұрын
Thank you very much.
@petroskalogeras42433 ай бұрын
Great Work
@nitheshn70193 ай бұрын
This is truly a 💎 website
@mcwahaab3 ай бұрын
We are grateful, Rick. A quick one. Have you been able to create videos showcasing the PowerQueryHow resources? It can sometimes be difficult to read written information and follow instructions. For many of your audiences, it might appear more convenient to have step-by-step videos instead. Please advise.
@BIGorilla3 ай бұрын
Hi. This video goes through what the website looks like and the features it has. I do reference to pqhow when relevant in a video. Yet covering all M functions on video would take ages. There's more than 1000 functions. I'm trying to cover the most important ones though :)
@andreluistomaz39303 ай бұрын
Great Job! Props, man!!! ❤
@BIGorilla3 ай бұрын
🚀🚀!!
@GosCee3 ай бұрын
Thank you for all the hard work you do to share your knowledge with us, Rick. I am excited to check out the site - it definitely looks like a great resource to help us master Power Query.
@BIGorilla3 ай бұрын
Please do! If it can help you in any way, my goal is achieved 😁
@minadev12 ай бұрын
Amazing!!!!!!
@michaelangellotti57413 ай бұрын
Awesome work ... thanks. Does your site explain or allow for contributors?
@BIGorilla3 ай бұрын
Yes. Contributors are welcomed. Each page has a ‘contribute’ button at the bottom. And you can also send something directly to rick@gorilla.bi. 👌
@geovanrocha28223 ай бұрын
Thanks for making that available.
@BIGorilla3 ай бұрын
No problem!
@foyezahmed21663 ай бұрын
Thank you very much 😀
@BIGorilla3 ай бұрын
You're welcome 😊
@mohamedfouad79583 ай бұрын
Thanks for your efforts. The site will be one of the best references of M language.
@BIGorilla3 ай бұрын
Thank you for the trust. And don't forget, if you want you can also contribute to the site. I'm happy to add good examples :)
@hichamhadj96403 ай бұрын
This is awesome list.generate (thanks)
@BIGorilla3 ай бұрын
Glad you like it!
@txreal22 ай бұрын
Buy his book 📕! It’s a treasure
@adilsonsoledade11713 ай бұрын
Really amazing. It is already in my list of favorites. Thanks a lot!!
@BIGorilla3 ай бұрын
Glad you like it!
@ankitsaxena59663 ай бұрын
You are Amazing.....
@BIGorilla3 ай бұрын
No, you are amazing! Thanks for commenting :)
@NhiNgo-up8jsАй бұрын
thank you
@raulparra603 ай бұрын
Un sitio web obligatorio de consulta. Gracias por el sitio web.
@BIGorilla3 ай бұрын
Muchas gracias Raul ☺️
@ismaelkourouma55583 ай бұрын
Hummm Want to start with the M language but humm! It seems strong ! I know that the purpose of this video is to give the way to learn M language but for a beginner, what do you recommend? Thanks
@BIGorilla3 ай бұрын
I recommend our new book: The Definitive Guide to Power Query M: geni.us/OFB3
@KelvinKeahey3 ай бұрын
This is awesome. Excellent information. Thank you so much!
@BIGorilla3 ай бұрын
Glad to read your enthusiasm. Enjoy!
@bravucod3 ай бұрын
Love the website. If you could include the a M-code formatter that will help tons. Thanks
@BIGorilla3 ай бұрын
Not sure what you mean. The M code is formatted. Can you elaborate
@bravucod3 ай бұрын
@@BIGorilla I meant adding a power query formatter
@kebincui3 ай бұрын
Very helpful. Thank you Rick 👍❤
@BIGorilla3 ай бұрын
Glad it was helpful, thanks Kebin!
@williamarthur48013 ай бұрын
Your explanation of splitter by nothing is so much clearer than MS Docs. Also your site is relatively easy to navigate compared to some others ( c . w 🙄🙄).
@BIGorilla3 ай бұрын
Thanks so much :) That reminds me, I still have some other splitters left to document. May look into that soon!
@raitup003 ай бұрын
Add it to my bookmarks!
@BIGorilla3 ай бұрын
Great!
@walidkhlil28723 ай бұрын
Great thanks
@BIGorilla3 ай бұрын
You are welcome Walid. Hopefully more people will find it useful :)
@djl87103 ай бұрын
Thanks!
@BIGorilla3 ай бұрын
Welcome!
@DataisKing3 ай бұрын
Is there a site that you know of that has custom functions?
@BIGorilla3 ай бұрын
Custom functions for the M language? I'm working on a collection of them, but it's currently not available yet. Other than that, you may find some Github pages out there from different individuals.
@SamehRSameh3 ай бұрын
How can i change value in column in nested table based on condition?
@stevecassell3 ай бұрын
😂
@fabianstoll28 күн бұрын
Why did you remove the input and output? For example, the List Functions Overview looks different.
@BIGorilla28 күн бұрын
You’re right, I removed it recently. After some asking around, and my own thoughts, I figured that part wasn’t as useful as I hoped. It took up real estate, and for some functions with long descriptions, I felt it made things feel cramped. So I decided to remove it. It’s still in the video though. Well spotted.
@fabianstoll27 күн бұрын
@@BIGorilla Thanks for answering. I thought this is a cool idea as I struggle with the data types. But I will for sure find other useful information on your website.