Power Query! Uggg - Where do you start? | Power BI

Not a coder? Don't understand Power Query M syntax? Power Query can be fun, but also can turn complicated. Learning Power Query can make Power BI and Excel very rewarding. Adam has some resources to get you started in your journey.

Concept: Roche's Maxim

Beginning the journey:

Power BI Learn (Free)

Course: Power BI Blueprint

Course: Power Query Course - Curbal

Later on...

30 Day Challenge: Query Folding - Alex Powers

Book: Collect, Combine and Transform Data Using Power Query in Excel and Power BI - Gil Raviv

Course: Power Query Academy

Some more advanced things...

Blog: Imke Feldmann

Blog: Chris Webb

Blog: Ken Puls

Blog: Excelerator BI

Course: M Language Course - Curbal

Documentation: M Language Reference


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #PowerQuery #GuyInACube

[discrate]

Material for learning is almost unlimited, the only limited thing is my time 😀

[Fernando_Calero]

What about the book Master your Data with Excel and Power BI from Ken Puls and Miguel Escobar

[massimocolaceci]

Thanks Adam for these "Where do you start?" videos. Imke's website was the new one to me. I bookmarked them all!

[PatrickWallet]

Thanks for your video! It’s the same for every tool: practice makes perfect. And besides all these great resources, don’t forget to learn about dimensional modeling (star schemas) 😃

[auroraedberg]

Thanks, a few new contents to look at. I also liked Enterprise DNA''s Data modeling course, it explained many things in a clear and understandable way.

[ayouberrarhbi]

Great video Adam! I hope there will be a "Where do you start" video for Dataflows !

[frankschadler]

Thank you for the very good summary, Adam. I missed Kens book and Lars Schreibers notepad++ M API.

[pakipower]

Thanks Adam for the links.
Can you guys do a detailed video on Python with PBI?
Thanks in advance.

[anmolshukla]

Hello! I'm not sure if this question is appropriate to ask here or not. I have the following question. We have multiple users who have the ability to make their own BA reports. For a brief summary of requirements, we have created one generic data set that will be used by each and every user. Furthermore, this dataset is currently published in one workspace in the Power Bi service. How should we grant access to this dataset? If we give them access to make changes in generic data set, it may happen that the data set will overwrite itself if different people make different changes. PowerBI data set live connection is not possible because they do not define measures, columns, etc. Would you please suggest what the best method should be?

[thomasleblanc]

Please don't teach 'them' ETL/ELT in PowerQuery, PLEASE!!!