Posts tagged #M Code

Extracting SQL Database/Table Names From Your Power BI Dataset!

Video by: Reid Havens

Learn how to query the XMLA end-point in a Premium (Per User or Capacity) workspace to extract all the Power Query M Code, and parse out your SQL Database names, table, names, and parameters from your queries. Tune in to learn more.

RELATED CONTENT 🔗

Extracting All M-Code from a Power BI Dataset

(Livestream Replay) Design Scalable BI Solutions with BI Solution Algebra - with Chris Wagner

DESCRIPTION 📄

Join Chris Wagner and Reid Havens as they talk about BI Solution Algebra, a framework for designing business intelligence solutions that are scalable, efficient, and cost-effective. They will share their insights and tips on how to choose the right mix of front-end, model, ETL, and other components to optimize your data analytics efforts. Whether you are a beginner or an expert, you will learn something new and useful from this lively and engaging conversation. Don’t miss this opportunity to learn from two of the best in the field!

GUEST BIO 👤

Christopher Wagner is a passionate data evangelist and a leader in data solutions. He is the Director of Data Solutions for Baker Tilly, a leading digital solutions, advisory, tax and assurance firm. He is also the founder of KratosBI.com, a website that provides resources, tutorials and insights on data and analytics. He hosts the Data Gods YouTube channel, where he shares his knowledge and experience with data enthusiasts and professionals.

Christopher has over two decades of experience in the data and analytics field, working with various technologies, platforms and tools. He has helped many organizations transform their data into valuable insights and actionable outcomes. He believes that data is the most powerful asset in the digital age, and he strives to make it accessible and understandable to everyone.

RELATED CONTENT 🔗

Website
YouTube
LinkedIn
X (Twitter)
Engagement

Starter Extensions for Visual Studio Code and Power BI (with Štěpán Rešl)

Video by: Reid Havens

Learn about a good starter pack list of extensions (plug-ins) for Visual Studio Code (VS Code). These extensions will be useful for: data modelling (DAX, Power Query), Git Management, Power BI administration, SVG/XML/Java scripting, custom visual development, and more! Tune in to find out.

GUEST BIO 👤

"Don't say something cannot be done, or someone who doesn't know will come and do it.". This motto describes me very well. I would say because I am trying to find a path even on fields where paths shouldn't be. I'm the MVP of Data Platform (Power BI) and a co-founder of a company called DataBrothers, where I work as a Lead technical consultant. Primarily I am working with Microsoft Power Platform Technologies (Power BI, Flow / Automate, and PowerApps) and am the Author of the Czech PBI blog Jakna Power BI (translated "How to Power BI").

RELATED CONTENT 🔗

Štěpán's LinkedIn
reporTee (Power BI guided learning)

(Livestream Replay) Leveling Up Power Query - Beyond the U/I (with Chandeep Chhabra)

DESCRIPTION 📄

Learning how to solve advanced problems using the M language which are beyond the scope of Power Query User Interface. Discover the beauty of the mash-up (m) language, additional functions that you can't find using just the U/I, learn about parameters and query types, and more. Tune in to find out!

GUEST BIO 👤

Chandeep Chhabra works with clients around the world on training and consulting projects on Excel and Power BI. Prior to starting Goodly (his venture), he worked as a Financial Analyst for an Investment Bank in Mumbai, India. Follow and connect with Chandeep online:

RELATED CONTENT 🔗

Blog
YouTube
LinkedIn
Twitter

Posted on August 18, 2023 and filed under Livestreams, Power Query.