Power BI Weekly
Issue #103 - 30th March 2021
In the last week, we've been told about the Power BI inheritance of MIP labels from Azure Synapse Analytics is in public preview, meaning that any sensitivity labels from Synapse or Azure SQL DB will be carried through to Power BI. Otherwise, we've been given a helpful Guide to enabling your organization to use Power BI in Microsoft Teams, together with PowerShell snippets to help admins with the technical side of the process. The Power BI team has also highlighted the Microsoft Business Applications Launch Event taking place next Tuesday, for those that want to know more about the Power Platform release wave 1.
Do you like using cards on your reports? Well, so do I. Alberto Ferrari has described how to Optimize card visuals in slow Power BI reports with some simple tricks. Chris Webb is continuing the mega series about file types, ADLSgen2 and Synapse with a blog describing how to Optimise The Performance Of Combining Data From Multiple Parquet Files In Power Query/Power BI. And finally, Adam Saxton has provided a great tip to improve the usability of your reports in the video Help your Power BI report users with an Information Panel. As ever, a clever use of PowerPoint and Power BI bookmarks can give people a better experience while navigating around your report.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) walks through Optimising The Performance Of Combining Data From Multiple Parquet Files In Power Query/Power BI
- On the Power BI community blog, Djordje Medakovic (@DjMedakovic) provides A small contribution towards a better user experience
- Also on the Power BI community blog, Elmothana2 writes about Simple, but so effective functionality in Power BI
- Also on the Power BI community blog, Liang Lu covers Using regular expressions in Power BI Desktop
- On the MSSQLTips site, Kenneth A. Omorodion writes about Common Data Transformations in Power Query
- Jeff Lenning (@Exceluniversity) describes how to Pivot Text Values with Power Query
- Bas Dohmen (@HowToPowerBI) talks about Fixing PIVOT errors in Power BI
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) explains How to convert Stack Data into Unstack different approaches | Unstack Uneven Data Excel Power Query
- Reid Havens (@HavensBI) covers Power Query – What is it good for? Absolutely everything! (with Gil Raviv)
- Brian Julius explains how to Unleash The Potential of Group By With All Rows
- Alex Badiu (@BadiuAlexandru) covers Hierarchies In Power BI Visualizations
- On the CSG Pro blog, Brian Grant (@BrianGrantBI) explains how to Detecting Overlapping Contracts with List.Dates() in Power BI
🧩 Data Modeling
- Darren Gosbell (@darrengosbell) writes that DAX Studio 2.15 Released
- Matt Allington (@ExceleratorBI) blogs about Building a P&L in Power BI – Part 2 (Percentages)
- On the SQLBI blog, Marco Russo (@marcorus) talks about DAX.do
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a few tutorials: COUNT, COUNTA, COUNTAX, COUNTX – DAX Guide, Addition, Subtraction, Multiplication, Division – DAX Guide, And, Or, NOT – DAX Guide, Concatenation – DAX Guide and Greater than, Greater than or equal to, Less than, Less than or equal to – DAX Guide
- Hima Bindu Marri (@sivahimabindu) explains How to COUNT in Power BI | COUNT, COUNTA, DISTINCTCOUNT, COUNTBLANK,COUNTROWS, DISTINCTCOUNTNOBLANK
- On the Towards Data Science blog, Salvatore Cagliari shares A hard lesson on Filter Context with Power BI and DAX
- On the CSG Pro blog, Brian Grant (@BrianGrantBI) talks about Grain Shifting Calculations in Power BI (The “Repeating Shipping Costs” Problem)
- Ruth Pozuelo Martinez (@CurbalEN) shares DAX Fridays #201: How to create virtual tables using DAX
- Dhruvin Shah (@DhruvinShah16) discusses a DAX Code Formatter in Power BI
- Sam McKay (@_EnterpriseDNA) explains how to Take Your Analysis To Another Level w/DAX Formula Patterns
- Greg Philps talks about DAX Calculations - Power BI Best Practices
- Tessa Hurr (@tessahurr) explains how to Delete sources for DirectQuery over Microsoft Power BI datasets and Azure Analysis Services
- Ashish Mathur (@ExcelAshish) describes how to Determine latest condition of each equipment and show a month wise count
- Parv Chana (@parvchana) writes about Multiple Slicers-Use “OR” Condition To Visualize Data
📊 Report Authoring and Interactivity
- On the Power BI community blog, Pragati Jain shares a Pie chart Illusion on a Map
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) walks through Optimizing card visuals in slow Power BI reports
- Mara Pereira (@datapears) shares some Power BI visualisation ideas: using images in slicers, filters and matrix visuals
- Hima Bindu Marri (@sivahimabindu) describes how to Dyamically change the title of a visual in Power BI
- Adam Saxton (@GuyInACube) describes how to Help your Power BI report users with an Information Panel
- Tessa Hurr (@tessahurr) talks about the Ribbon search bar in Microsoft Power BI
- On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) writes about a Printable report in Power BI
🚀 Deployment, Security and Operations
- On the Power BI blog, Anton Fritz (@AntonFritz15) announces Power BI inheritance of MIP labels from Azure Synapse Analytics (Public Preview)
- Patrick Leblanc (@GuyInACube) talks about 3 ways to REDUCE DATA In Power BI Desktop (No Premium needed!)
- Gilbert Quevauvilliers (@GilbertQue) describes How to get an App feature on the Power BI Home page and in users Apps
- Erik Svensen (@donsvensen) writes about Multivalue parameters in Power BI paginated report when using PowerAutomate to export to file
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) writes about Essential Actions for Governing Power BI - with Melissa Coates
🌐 General
- On the Power BI blog, Lukasz Pawlowski (@lukasztweets) shares a Guide to enabling your organization to use Power BI in Microsoft Teams
- Also on the Power BI blog, Miguel Martinez (@maikelson) explains how to See all the Power BI updates at the Microsoft Business Applications Launch Event
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 184 - Power BI March 2021 Feature Summary
- On the MSSQLTips site, Sean Lee shares some Study material for exam DA-100 Analyzing Data with Microsoft Power BI
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 146
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (Mar 27, 2021)
- On the Towards Data Science blog, Nathan Cheng discusses a Minimum Viable Streaming Dashboard in Power BI: Part 2
- Allison Kennedy talks about Freediving and Your Lungs: Charticulator Custom Visual for Power BI