Power BI Weekly

Issue #70 - 4th August 2020

Absolutely no official updates to share with you this week, other than the fact that DAX Studio 2.12.1 has been released (which many of you now using the External Tools feature in Desktop might be interested in). Despite the lack of announcements, this week's newsletter is jam-packed full of content. Here's a few highlighted articles: Mark Walter has described how to Replace full records based on partial strings in Power Query, Gil Raviv has written about Weekly-Based Time Intelligence, Aveek Das has described Working with Power BI Data Models in Visual Studio Code and Amit Chandak has explained how to Display a Label Only on the Last Data Point of the Line Visual for a Trend.

🛠️ Data Prep

Daniil Maslyuk (@DMaslyuk) covers Converting hexadecimal to decimal numbers in Power Query
Soheil Bakhshi (@biinsightnz) shares some Quick Tips: Converting Hexadecimal, Oct and Binary to Decimal in a Single Power Query Function
On the Enterprise DNA blog, Melissa de Korte walks through Turning Calendar Type Layout Into Tabular Format In Power BI Using Query Editor
Also on the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) discusses Creating a Dynamic Date Query Table in Power BI: A Query Editor Tutorial and explains how to Convert The Date Table Function Into A Table Query in Power BI
Mark Walter (@storybicom) walks through Replacing full records based on partial strings in Power Query.
Matthew Peterson (@mattpetersonbi) describes Using Web-Sourced NFL Stats in Data Analysis
Gilbert Quevauvilliers (@GilbertQue) writes Did you know you can query data from AWS S3 into Power BI?
Vivek Ranjan (@imvivran) writes about Dynamically Combine Multiple Sheets p 1: Power Query and writes about Dynamically Append Multiple Sheets p 2: Power Query
Ruth Pozuelo Martinez (@ruthpozuelo) delves into Running totals in power query??? Yes, you can :)
Leila Gharani (@LeilaGharani) explains how to Consolidate & Clean Multiple Excel Sheets in One Pivot Table
Reid Havens (@HavensBI) talks about Performance, Optimization, and Intelligent Error Handling in Power Query
Marcus Wegener (@PowerBIler) shares Hey Peter! In Power BI Spalte aus Beispielen [German]
On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) writes about Power Query : 3 fonctions pour manipuler les heures [French]
Matthew Roche (@SQLAllFather) shares some Weekend reading: New dataflows docs
Asanka Padmakumara (@asanka_e) describes How to create a Power BI Dataflow Programmatically

🧩 Data Modeling

Darren Gosbell (@darrengosbell) highlights the DAX Studio 2.12.1 release
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a number of blogs: How Many Staff Do We Currently Have – Multiple Dates Logic In Power BI Using DAX, How To Compare Two Lists Of Calculated Data Virtually – An Advanced DAX Technique, Sam McKay Cfa How To Use The COUNTROWS DAX Function In Virtual Tables and Manage Multiple Date Calculations In Your Fact Table – Advanced Power BI Technique
On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) writes about Two Options to Organise Measures
Gil Raviv (@gilra) writes about Weekly-Based Time Intelligence in Power BI
Marc Lelijveld (@MarcLelijveld) writes about External Tools: Document your Power BI Model
Phil Seamark (@PhilSeamark) describes how to Automatically create measures in Power BI using VS Code
On the SQL Shack blog, Aveek Das (@avikoleum) covers Working with Power BI Data Models in Visual Studio Code
Erik Svensen (@donsvensen) shares an External tool to connect Excel to the current PBIX file
Matt Allington (@ExceleratorBI) writes MEDIANX Returns Blank in DAX – Part 1
On the SQLBI blog, Marco Russo (@marcorus) writes about Arbitrary combination of measures and calculation items
On the BlueGranite YouTube channel, Eric Lofstrom talks about Calculation Groups in Power BI with Tabular Editor
Adam Saxton (@GuyInACube) discusses Lots of DAX to go to the next level with Power BI... (Roundup | July 27, 2020)
On the Towards Data Science blog, Nikola Ilic (@DataMozart) shares TIQ Part 4—Being Time intelligent in Power BI and writes about VertiPaq—Brain & Muscles behind Power BI
On the CSG Pro blog, Brian Grant (@BrianGrantBI) shares the Elements of DAX (series)
Parker Stevens (@PowerBIElite) discusses DAX for Power BI - Dynamic % Change
Dhruvin Shah (@DhruvinShah16) describes how to Turn off Automatic Detection of Data Type in Power BI Desktop
Ruth Pozuelo Martinez (@ruthpozuelo) shares DAX Fridays #183: Virtual relationships with INTERSECT
On the dev.to blog, Kevork Keheian (@KKeheian) provides an Introduction to DAX
On the Power BI Community blog, Greg Deckler (@GregDeckler) writes To **bleep** With Time Intelligence
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) describes Generating Row Number in Power BI Visualization Using DAX

📊 Report Authoring and Interactivity

Chris Hamill (@ChrisHamill17) writes about a Creative filter display
Chris Webb (@cwebb_bi) writes about Dynamically Generated Lines On A Map In Power BI Using DAX, WKT And The Icon Map Custom Visual
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes how to Showcase Insights Using The Multi Threaded Dynamic Visuals Technique In Power BI and writes about Simple Visualization Techniques For Your Power BI Reports
Mike Allen (@MikeAinOz) provides some Guidance for the PBITask Custom Visual v1.0.2
Adam Saxton (@GuyInACube) says that OVERLAPPING Power BI visuals can be FRUSTRATING!?! How to avoid?
Patrick Leblanc (@GuyInACube) writes about NEXT LEVEL Conditional Drill in Power BI Desktop with buttons
Spencer Baucke (@JSBaucke) covers Report Navigation in Power BI and talks about Report Page Tooltips in Power BI
Reid Havens (@HavensBI) walks through Using Images as Button States in Power BI
On the MSSQLTips site, Scott Murray covers Power BI Personalization
Ruth Pozuelo Martinez (@ruthpozuelo) describes How to easily sketch your Power BI reports with your remote team / customers
On the Power BI Community blog, Amit Chandak (@amitchandak78) writes about Regional Language Customization in Tables or Slicers and describes how to Display Label Only on the Last Data Point of the Line Visual for a Trend
On LaDataWeb, Ignacio Barrau (@ignacho_07) writes about Bookmarks - Mejora la UX con Botones pintados [Spanish]

🚀 Deployment, Security and Operations

Laura Graham-Brown (@Laura_GB) describes how to Endorse a Dataset as Promoted or Certified
On the Blue Granite blog, David Eldersveld (@dataveld) talks about Embedding Power BI? Choosing Between PBI Premium or Embedded
Nicky van Vroenhoven (@NickyvV) describes Using the Power BI REST API as Admin
Dhruvin Shah (@DhruvinShah16) explains how to Prevent Users from creating Classic Workspace from Power BI | Block Classic Workspace Creation

🌐 General

Kelly Kaye and Sandy Rivas share the video: Thank you to the Power BI Community for five Years
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 154 - July 2020 Power BI Desktop Update
Matthew Roche (@SQLAllFather) discusses Roles and Responsibilities in the Data Culture
Paul Turley (@paul_turley) writes about Doing Power BI the Right Way: 1. Futureproofing Power BI solutions
Lars Schreiber (@SchreiberLars) shares a podcast: Expert's Talk: Adam Saxton about personal branding, self-motivation and the passion for learning
Dhruvin Shah (@DhruvinShah16) explains how to Generate Microsoft Teams Attendance Report Using Power BI with few Clicks and how to Develop Microsoft Teams Attendance Report Using Power BI
On the Beyond Impact blog, Branden Cecil writes about the Power BI Updates: What you should know (July 2020)
On the Towards Data Science blog, Jenny Dcruz describes How to visualize data using Power BI
Sam McKay (@_EnterpriseDNA) covers Delivery App Review - Power BI Challenge 4 Submission and discusses Optimizing Internal Processes w/Power BI - Enterprise DNA Webinar Series
Adam Saxton and Patrick Leblanc (@GuyInACube) shares the REPLAY Power BI tips from the Pros – LIVE (Aug 1, 2020)