Introducing Power Query How (Master the M language)

Рет қаралды 4,712

Күн бұрын

PowerQuery.How is a website that provides M language documentation. You can find functions, syntax, enumerations and lots of examples. You can find the website here: powerquery.how/
I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: geni.us/ODZl8
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
Website: gorilla.bi
SUBSCRIBE TO MY CHANNEL
kzfaq.info?sub_con...
TIMESTAMPS
00:00 Introduction
00:51 Navigation
02:20 Overview pages
03:32 Motivation for website
03:56 Search Menu
05:05 Updated Articles
05:40 Code Boxes and Formatting
06:39 References: Related Functions
07:24 References: Articles
08:19 References: Enumerations
10:03 Contributions
LET'S CONNECT:
Blog: gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#powerqueryhow #powerquery #m

Пікірлер: 89

@BIGorilla Ай бұрын

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!

@danyos777 Ай бұрын

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!

@BIGorilla Ай бұрын

You're very welcome! I agree. It’s still a work in progress, but helpful nonetheless. Enjoy!

@robbe58 Ай бұрын

Your website is a masterpiece. Structured very well, clear, and pleasant to read. Just a nice tool when working with Power BI. 👏👏🙏

@BIGorilla 10 күн бұрын

Many thanks!

@JohnKpl 25 күн бұрын

You spoke very mildly about Microsoft's site. Their sites very rarely provide answers. Great peace of work!

@raimundojs9547 Ай бұрын

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!

@BIGorilla Ай бұрын

Always happy to read your response raimundo. If you ever want to contribute, you know where to find me 😁

@GeertDelmulle Ай бұрын

This website is really nice: everything is put together so well. Got it bookmarked for reference. :-) Thanks for all the hard work, Rick!

@BIGorilla Ай бұрын

Thanks for your support Geert!

@RobertoStaltari Ай бұрын

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.

@BIGorilla Ай бұрын

I'm glad to hear that, thanks you Roberto. I hope it lives up to the expectations!

@barttrudeau9237 Ай бұрын

Thank you so much for this work you have done, it's a tremendous benefit to the community

@BIGorilla Ай бұрын

Happy to help!

@ftmagicart Ай бұрын

Thank you very much for sharing your work through this site. I use it very often.

@BIGorilla Ай бұрын

You do? Excellent! I’m about to give it some more love coming time :)

@rodrigochavez7 Ай бұрын

Looking forward a Power Query course from you mastering the M language! Thank you for this amazing resource

@BIGorilla Ай бұрын

Me too Rodrigo. It may take a little while still as I haven’t started , but it’s on the roadmap. 😁

@adrianoschwenkberg6773 28 күн бұрын

i bought the printed book to support your work. nice work rick.

@baskis69 27 күн бұрын

I love this website, without a doubt the reference website for M language.

@zahoorsarbandi2982 Ай бұрын

Of course, this website is 100 times better than Microsoft Power Query pages which is messy, unclear, and lacking in logic

@BIGorilla Ай бұрын

❤🙏

@BHASKARJOSHI-cw7qn Ай бұрын

My first preference on Power Query

@gef24 Ай бұрын

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.

@BIGorilla Ай бұрын

❤ appreciate that! Thanks for the compliment

@CAKimberlyLewis 27 күн бұрын

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!

@BIGorilla 10 күн бұрын

That is awesome!!

@Blueboy30 Ай бұрын

Fantastic. I'm sure it will be a great reference. Microsoft website, I find can be very confusing.

@felipesignorellireis7839 Ай бұрын

Amazinnnnng 🇧🇷 Love the work. Lot of work.

@BIGorilla Ай бұрын

Thanks Felipes!

@petroskalogeras4243 Ай бұрын

Great Work

@mohammed333suliman Ай бұрын

Thank you so much , you are spending effort and time to make information accessible

@BIGorilla Ай бұрын

It's my pleasure; there’s so much to learn :)

@ramruttunaubeeluck9235 Ай бұрын

Thank you very much.

@7213261 Ай бұрын

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!

@BIGorilla Ай бұрын

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 😁

@adilsonsoledade1171 Ай бұрын

Really amazing. It is already in my list of favorites. Thanks a lot!!

@BIGorilla Ай бұрын

Glad you like it!

@nitheshn7019 Ай бұрын

This is truly a 💎 website

@andreluistomaz3930 Ай бұрын

Great Job! Props, man!!! ❤

@BIGorilla Ай бұрын

🚀🚀!!

@kebincui Ай бұрын

Very helpful. Thank you Rick 👍❤

@BIGorilla Ай бұрын

Glad it was helpful, thanks Kebin!

@KelvinKeahey Ай бұрын

This is awesome. Excellent information. Thank you so much!

@BIGorilla Ай бұрын

Glad to read your enthusiasm. Enjoy!

@GosCee Ай бұрын

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.

@BIGorilla Ай бұрын

Please do! If it can help you in any way, my goal is achieved 😁

@geovanrocha2822 Ай бұрын

Thanks for making that available.

@BIGorilla Ай бұрын

No problem!

@TheMoh148 Ай бұрын

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.

@kaizen52071 Ай бұрын

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!!

@BIGorilla Ай бұрын

That’s the biggest compliment! Happy to hear that 👌😋

@mohamedfouad7958 Ай бұрын

Thanks for your efforts. The site will be one of the best references of M language.

@BIGorilla Ай бұрын

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 :)

@minadev1 14 күн бұрын

Amazing!!!!!!

@foyezahmed2166 Ай бұрын

Thank you very much 😀

@BIGorilla Ай бұрын

You're welcome 😊

@ankitsaxena5966 Ай бұрын

You are Amazing.....

@BIGorilla Ай бұрын

No, you are amazing! Thanks for commenting :)

@hichamhadj9640 Ай бұрын

This is awesome list.generate (thanks)

@BIGorilla Ай бұрын

Glad you like it!

@txreal2 9 күн бұрын

Buy his book 📕! It’s a treasure

@walidkhlil2872 Ай бұрын

Great thanks

@BIGorilla Ай бұрын

You are welcome Walid. Hopefully more people will find it useful :)

@djl8710 Ай бұрын

Thanks!

@BIGorilla Ай бұрын

Welcome!

@mcwahaab Ай бұрын

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.

@BIGorilla Ай бұрын

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 :)

@michaelangellotti5741 Ай бұрын

Awesome work ... thanks. Does your site explain or allow for contributors?

@BIGorilla Ай бұрын

Yes. Contributors are welcomed. Each page has a ‘contribute’ button at the bottom. And you can also send something directly to rick@gorilla.bi. 👌

@raitup00 Ай бұрын

Add it to my bookmarks!

@BIGorilla Ай бұрын

Great!

@bravucod Ай бұрын

Love the website. If you could include the a M-code formatter that will help tons. Thanks

@BIGorilla Ай бұрын

Not sure what you mean. The M code is formatted. Can you elaborate

@bravucod 27 күн бұрын

@@BIGorilla I meant adding a power query formatter

@DataisKing Ай бұрын

Is there a site that you know of that has custom functions?

@BIGorilla Ай бұрын

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.

@williamarthur4801 Ай бұрын

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 🙄🙄).

@BIGorilla Ай бұрын

Thanks so much :) That reminds me, I still have some other splitters left to document. May look into that soon!

@ismaelkourouma5558 Ай бұрын

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

@BIGorilla Ай бұрын

I recommend our new book: The Definitive Guide to Power Query M: geni.us/OFB3