Power BI Weekly
Issue #84 - 10th November 2020
Just the one update for you in what has been a relatively quiet week, and that's the Paginated Report November 2020 Feature Summary, which includes new sample reports to help you get up and running, the capability to "search" for values in parameter dropdowns, the ability to download an RDL file from the Power BI Service, and the option of applying the "page view" mode as a URL parameter. Read that blog to find out more
Elsewhere this week, Matt Allington has updated an old blog describing Affordable Power BI Premium for Small Businesses, factoring in the new updates around the new Premium Per User licensing option. One thing that's particularly interesting is Microsoft's new stance on using Power BI Embedded as an affordable means for accessing Premium content - it seems there's a bit of ambiguity here. Read Matt's blog for more information. Otherwise, a couple of technical bits of content for you this week: Patrick Leblanc has described Why you should use DAX Studio with Power BI with which I concur wholeheartedly, and Zhenbo Wang has described how to Convert the start time and end time into multiple rows with 30 minutes interval using both M and DAX methods.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) writes about Handling Multi-select In Power BI Dynamic M Parameters
- Mimoune Djouallah (@mim_djo) writes about a Dynamic Weekend using Parameter in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) shares Dynamic M Query parameters explained: How it works, security concerns and limitations and explains how to Add multiple missing columns if missing in Power Query
- Jon Acampora (@excelcampus) describes how to Split by Delimiter into Rows (and Columns) with Power Query
- On the Power BI community blog, Zhenbo Wang explains how to Convert the start time and end time into multiple rows with 30 minutes interval
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) shares Left Outer Join - What it is and how to use it in Power BI and Power Query
- Kreimir Ledinski writes about Nested functions and Table.Buffer
- Reid Havens (@HavensBI) shares the video: "Why Dataflows?" with Matthew Roche
- Laura Graham-Brown (@Laura_GB) describes how to Create a Dataflow for Reusable Transforms
- On the Towards Data Science blog, Jenna Eagleson (@JennaEagleson) blogs about Power BI: Understanding M
- Nicky van Vroenhoven (@NickyvV) describes how to List All Functions in Power Query with #shared
- John White (@diverdown1964) explains how to Exceed the 500,000 row limit in Application Insights and Log Analytics with Power BI
- On the MSSQLTips site, Kenneth A. Omorodion talks about Visualizing Azure Resource Metrics Data in Power BI
🧩 Data Modeling
- Patrick Leblanc (@GuyInACube) talks about Why you should use DAX Studio with Power BI
- Gilbert Quevauvilliers (@GilbertQue) shares a Quick tip on how to ensure your Format String Expression in the Power BI Calculation Group works
- Also on the Power BI community blog, Allison Kennedy writes about Organizational Data Types in Excel using Power BI datasets
- On the Enterprise DNA blog, Brian Julius writes about RANKX In Power BI – Developing Custom Tiebreakers
- Also on the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a number of blogs: DAX Variables And Comments To Simplify Formulas, Power BI Quick Measure Feature, Combining DAX Patterns Or DAX Formulas In Power BI and Advanced DAX Functions: Calculating Profit Contribution
- On the Power BI community blog, Amit Chandak (@amitchandak78) writes about Distributing/Allocating the Yearly Target (Convert to Daily Target): Measure (Daily/YTD)
- On the Forsight BI blog, Ahmed Oyelowo (@AhmedOyelowo) writes about 3 DAX Table Functions You Must Master
- On the Towards Data Science blog, Peter Hui discusses Power BI Column vs Measure. Which one should I use and when?
- Mark Walter (@markwaltercpa) writes Excel to Power BI Part 3: Getting Started With DAX
- Reid Havens (@HavensBI) talks about Showing DAX Expressions When Using Power BI Datasets (Live)
- Dhruvin Shah (@DhruvinShah16) explains how to Find and Remove Last Occurrence from a String using Power BI DAX and writes that Power BI Shows Incorrect Measure Total How to fix it
📊 Report Authoring and Interactivity
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) describes how to Turn plain Matrix into brand new visual in Power BI
- On the Power BI Community blog, Icey Zhang describes how to Transform ‘report language’ based on buttons
- On the xViz blog, Bhupinder Singh writes about the Bubble Chart – Power BI Custom Visual Key Features
🚀 Deployment, Security and Operations
- Matt Allington (@ExceleratorBI) writes about Affordable Power BI Premium for Small Business
- Adam Saxton (@GuyInACube) explains that Publish to Web got some awesome new updates in Power BI!
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) writes about Dynamic Row Level Security in Power BI with NOT IN or NOT EQUAL Rule
- On the MSSQLTips site, John Miner (@JohnMiner3) explains how to Manage Power BI Dataset with PowerShell
- Martin Schoombee (@MartinSchoombee) describes Automating Power BI deployments: Trigger a refresh
- Alex J. Garcia (@SmartpowerB) discusses Power BI Dataset Certification – Delivering value to the organisation via improving high quality data sources visibility
🌐 General
- On the Power BI blog, Swati Gupta shares the Paginated Report November 2020 Feature Summary
- Wolfgang Strasser (@wstrasser) describes how to Direct Query your Data Lake Files using Azure Synapse Analytics and Power BI
- The Knee-Deep in Tech team (@KneeDeepinTech) shares Podcast episode 138
- Adam Saxton and Patrick Leblanc (@GuyInACube) covers 🔴 Power BI tips from the Pros – LIVE (Nov 7, 2020) (Member Chat 2nd Half)
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) share Episode 167 - What election? Let's talk about Power BI News
- Ulrik B. Carlsson (@crmchartguy) explains how to Create Record Links From Power BI to Unified Interface and Dynamics 365