Tag: Power Query
-
Nashville M365 Community Day 2026
The Nashville M365 Community Day (part of TN Days) took place today at the Nelson Andrews Leadership Lodge in Nashville, Tennessee. What a fun day and beautiful venue! 30 Power BI Tips & Tricks Thank you to everyone who came and drank from the firehose of my session! 30 tips in 50 minutes (well, 53…
-
Power BI at Work: Live Hands-On Developer Training
We’re thrilled to announce our new live Power BI foundations course, Power BI at Work! Whether you’re brand new to Power BI or looking to level-up in a fun group setting, our course gives you confidence to hit the ground running. Mark and I are both long time Power BI nerds who enjoy equipping others…
-
Atlanta Microsoft Business Intelligence User Group
Thank you to Teo and Damu for the opportunity to share 30 Power BI Tips & Tricks with the Atlanta Microsoft Business Intelligence User Group this evening. You are a great group! Thank you to all who attended and for the great questions! The PBIX Presentation file is below: PBI 30 Tips and Tricks Atlanta…
-
Power BI Tips & Tricks: Build a Date Table with Power Query
In the previous post, we looked at options and features to power up your Power Query experience. I’d like to build on that in this article. Perhaps the greatest feature of Power Query is the UI. Any user can perform dozens of transformations, both basic and complex, with only mouse clicks and no need to…
-
Power BI Tips & Tricks: Power Up in Power Query
Power Query is undeniably one of my favorite features of Power BI, and for that matter, Excel. Power Query packs a powerful punch for performing ETL (extract, transform, and load) tasks and it’s user interface makes completing these tasks pretty simple without having to write any code. I won’t expand on all of the reasons…
-
Nashville Modern Excel and Power BI User Group: 30 Power BI Tips & Tricks
It’s great to be back! Grateful for the opportunity to share at the Nashville Modern Excel and Power BI User Group’s October 2022 meeting. 30 Power BI tips in just over an hour! Thanks to everyone who attended in person and online, I hope you learned something new! PBIX presentation file is below: PBI 30…
-
M / Power Query: Table.HasColumns()
The Challenge Recently, I have been using Power Query to scrape data from web pages to load into Power BI for some side projects (more to come as these are completed, hint hint). The data from the web pages is good but inconsistencies do exist. Sounds like a pretty normal day for a data nerd,…