Improving Merging & Appending Power Query (Queries) with Ken Puls

Video by: Reid Havens

Learn an improved way to merge or append queries (as new) by adding an additional source applied step. Ken Puls will walk you through this, and why it'll benefit your query logic moving forward. Tune in to learn more!

GUEST BIO 👤

Ken Puls is the president of Excelguru Consulting Inc, a company dedicated to helping users get the most from their data. A blogger, software developer, author and trainer with over 20 years of accounting and IT experience, Ken's passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. Learn more about Ken at the links below!

RELATED CONTENT 🔗

Ken's Twitter
Ken's LinkedIn
Company Website
Company Blog
MonkeyTools

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)