Ben WattDec 13, 2020Power Query: Sort + Distinct, a quick tip.When you perform a Distinct operation in Power Query, the elimination policy is to keep the first instance it sees of the column(s) you...
Ben WattNov 30, 2020Browsing Tables & Columns in Microsoft Dynamics, using Power QueryI have several customers using Dynamics CRM and have built Power BI solutions using these as a data source. Dynamics CRM uses the Common...
Ben WattNov 3, 2020Power BI REST API with Python and Microsoft Authentication Library (MSAL)Update Sep 2021. Great to see you here! I suggest after you read read this blog, don't miss the other two additions to the series, where...
Ben WattJul 28, 2020Power BI theme tip: Page BackgroundUsing Power BI themes has allowed me to keep look and feel consistent. This is important to me as I put a lot of time and effort into...
Ben WattMay 26, 2020Analyzing your Microsoft Teams meeting attendeesUsing the new Microsoft Teams feature to track attendees leaving & joining your meeting.
Ben WattJan 14, 2020Power BI meets Meetup.comEver found it hard to keep up with all of the Meetup.com events you are interested in? Same here. So as a Power BI person I thought I'd...