QUICK INTRO to M QUERY in POWER BI and EXCEL // Beginners Guide to Power BI in 2024

In this video were going to look at the Mashup Query Language, or M Query in Power Query Editor. We're going to look at what it is, how it differs from DAX, and look at its basic structure so you can read and write it yourself

🕓 TIMESTAMPS
0:00 - Intro
02:25 - Basics
03:44 - Advanced Editor
04:04 - DAX vs M Query
05:44 - Syntax
15:24 - Custom Functions

-

📣 Get Demo Files HERE

🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.

📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more

🛒 Power BI TEMPLATES and more at our digital shop

❤ Other ways to SUPPORT us

📧 GET IN TOUCH

🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.

🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!

#PowerBI #DataAnalytics #BusinessIntelligence

[_logicking]

Woohoo thank you!! I play with m all the time and I’m looking forward your overview!!

[abediaz]

do you have a guide on your most used custom m codes?

[RajendarAg]

Hi Fernan,
I have embedded my Power BI Report with JAVA API using the (GroupID, DatasetID, ReportID) from PowerBI service.
I need to apply the Row level security using UserID, UserRoleID, ClientID values passing from the API.
Could you please help me with any work arounds on this task.?

[Pradeep]

Hi Bro can we connect Power BI with Informatica CDI(Cloud Data Integration)???

[timothyjones]

Good content but it is unnecessarily jerky due to the zoom-in zoom-out thing you got going. Why?