Thank you to Teo and Damu for the opportunity to share 30 Power BI Tips & Tricks to 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…
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…
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…
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…
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…