Power BI Weekly
Issue #17 - 23rd July 2019
This week, Imke Feldmann has provided a Text.RemoveBetweenDelimiters function for Power BI and Power Query, Alberto Ferrari has helped us understand Calculation Group Precedence, and Adam Saxton has spoken about Power BI REST API no-code options. Elsewhere, the Power BI team has given us a number of updates:
🛠️ Data Prep
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes Conditional Column in Power BI using Power Query; You can do anything!
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about Unpivot and Pivot Basics in Power BI – Query Editor Review
- On the Excelguru blog, Ken Puls (@kpuls) discusses Power Query Intellisense and Highlighting in Excel
- Jeff Lenning (@Exceluniversity) describes how to Fuzzy Match with Power Query
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) writes about Power Query in Excel for Mac: First Impressions
- Imke Feldmann (@TheBIccountant) provides a Text.RemoveBetweenDelimiters function for Power BI and Power Query
- On the MSSQLTips site, Scott Murray writes What I wish I knew when I started working with SQL Server Analysis Services
🧩 Data Modeling
- On the Power BI blog, Josh Caplan (@JoshCaplan1984) announces that Aggregations for petabyte-scale BI is generally available
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) blogs about Understanding Calculation Group Precedence
- On the RADACAD blog, Reza Rad (@Rad_Reza) describes how to Organize Power BI DAX Measures in Folders and discusses What Fields to Hide in Your Power BI Solution
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes a number of blog posts: Normalizing Results On Different Days In Power BI Using DAX, How To Calculate The MEDIAN Value In Power BI Using DAX, Placing Workday And Weekend Day Numbers Into The Date Table In Power BI, How To Deal With Products That Have Changing Prices Overtime In Power BI, Show Last N Sales Of A Customer Only Using Power BI, How To Download Latest Exchange Rates Into Your Power BI Model and on the Power BI community blog, explains How To Use Supporting Tables Within Your Data Model For Maximum Effect In Power BI
- Mimoune Djouallah (@mim_djo) describes Reproducing Primavera Select Columns in Power BI; aka Dynamically adding measures to a Matrix
- On the PowerPivotPro blog, Rob Collie (@robcolli3) covers FILTER – When, Why, & How to Use It (in Power BI too!)
- Chandeep Chhabra (@chandeep2786) writes about Actual v/s Budget calculations using DAX
⚙️ Report Design and Visualizations
- On the MSSQLTips site, Gauri Mahajan discusses Power BI Maps: Bubble, Shape and Filled Map Examples
- On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) talks about Icons upon Icons
- Matt Allington (@ExceleratorBI) writes about Conditional Formatting Using Icons In Power BI
⚙️ Data Exploration
- On the Power BI blog, Sujata Narayana announces that the New Filter Experience for Power BI Reports is now generally available
- Gil Raviv (@gilra) explains how to Find overlapping time periods using PowerQuery
🚀 Deployment, Security and Operations
- On the Power BI blog, David Magar describes how to Know What Your Premium Capacity Can Handle
- On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) writes about Gateway Management on Admin Center
- On the DataAP blog, Hariharan Rajendran provides Power BI Shared Dataset Cheat Sheet
- Adam Saxton (@guyinacube) discusses Power BI REST API no-code options
- Gilbert Quevauvilliers (@GilbertQue) writes about Enabling External Power BI Users to easily view App Workspaces or Apps shared with them
- Chris Webb (@cwebb_bi) blogs about SSASDiag: A Tool To Help Diagnose Analysis Services Problems
- On the Visual BI blog, Sathya Narayana Karthikeshwar (@karthikeshwar) discusses the Inheritance of Security from SAP BW System to Power BI - Part 1 and writes Understanding the n Key Difference between Power BI Report Server and Power BI Service
🌐 General
- On the Power BI blog, Amanda Cofsky (@MissAmandaN) provides the Power BI Desktop July 2019 Feature Summary
- Adam Saxton (@guyinacube) talks about the Power BI Slicer histogram, dynamic dates, gateway update and more (July 15, 2019)
- Devin Knight (@knight_devin) describes Power BI Monthly Digest – July 2019 with Manuel Quintana
- On the Power BI community blog, jfeil explains how to Be Our Friend: 2019 Season 2 Super Users