Power BI Weekly
Issue #208 - 23rd May 2023
This is your final reminder to register for the Microsoft Build conference, whose opening keynote kicks off at 9AM PDT (I'll leave you to calculate what time that is in your timezone!) I suggest you tune into this keynote, and then (if you're still awake) join Arun, Amir, Justyna and Patrick's keynote session Analytics in the Age of AI at 4PM PDT. You're not going to want to miss that one. We'll be talking about these exciting Build announcements on the endjin blog and endjin YouTube channel over the coming days, so stay tuned!
Back to reality - we've been given one announcement this week, which is better Admin Monitoring for Tenant Admins which consists of a new "Feature Usage and Adoption dataset and report", providing insights on users and activity, capacity usage and adoption growth, and other general auditing needs. Tenant Admins will be able to share these reports with other organization users if necessary, too. Elsewhere this week, Flávio Meneses has shared a New External Tool: Automated Checks which performs some helpful sanity-checks over a Power BI report to build a developer's confidence after making a round of changes; and Erik Svensen has shown how to use the Power BI Embedded playground in order to easily try/test another Power BI theme on your existing reports in the service.
🛠️ Data Prep
- On the phData, Gavin Pedersen (@gavin_PD) describes How to Parameterize Snowflake Data Sources in Power BI
- James Andrew (@MatadorSoftware) covers Easily import sample Power BI data using Python & Seaborn
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) explains how to Skip Files with Errors Benefit when Appending Data from a Folder in Microsoft Power BI, explains how to Create Custom Columns in Power Query | Separate Text & Numbers, discusses Split Data Techniques in Power Query and describes Split Data Techniques in Power Query | Non Breaking Spaces, Delimiters, Lower & Upper Case
- Chandeep Chhabra (@chandeep2786) talks about I Bet You Don’t Know All These Power Query Tricks
- Miguel Félix covers Query “invisível” [Portuguese}
- On the Select Distinct blog, David Laws (@SelectDistLtd) discusses Use a Database as a Data Warehouse to Enhance Power BI
🧩 Data Modeling
- Marc Lelijveld (@MarcLelijveld) blogs about The Hidden Impact of Keys in Your Power BI Data Model
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) writes about Change your focus over time in DAX Measures
- Darren Gosbell (@darrengosbell) describes Setting a dynamic default slicer value in Power BI
- On the RADACAD blog, Reza Rad (@Rad_Reza) discusses Power BI DAX: ALL vs. ALLSELECTED
- On the MSSQLTips site, Harris Amjad (@mssqltips) writes about Multiple Relationships on the Same Table in a Power BI Data Model
- On the Learning Science YouTube channel, Learning Science describes How to convert a date into Month Year format in Power BI
- Marco Russo (@marcorus) writes about Generative AI guidelines at SQLBI
📊 Report Authoring and Interactivity
- Mara Pereira (@datapears) describes Error bars tricks - Bar chart with rounded corners
- Adam Saxton (@GuyInACube) describes Enabling Drill-through with Power BI On-Object Editing and discusses What does Tooltip Auto-scale actually do in your Power BI Report?
- Erik Svensen (@donsvensen) explains How to try/test another Power BI theme on your existing reports in the service
- Vahid Doustimajd (@VahidDoustiM) blogs about Unleashing the Power of Color: Introducing "Coolors to Power BI Theme" Browser Extension
- Reid Havens (@HavensBI) describes Better Maps in Power BI with Icon Map - with James Dales
- Flávio Meneses shares a New External Tool: Automated Checks
🚀 Deployment, Security and Operations
- On the Power BI blog, Bogdan Blaga writes about Admin Monitoring for Tenant Admins
- Greg Deckler (@GregDeckler) explains How To Install And Use Windows PowerShell Cmdlets For Power BI
- Ignacio Barrau (@ignacho_07) covers [SimplePBI][CD] Auto Deploy informes de PowerBi con Azure Devops Pipelines [Spanish]
🌐 General
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 226
- On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) discusses Does a Power BI developer need Python?