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
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- 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
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- 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
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- 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)
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.