Power BI Weekly
Issue #50 - 17th March 2020
Woah - 50 editions. Big milestone, and in a couple of editions' time, it'll be a whole year's worth! So much great Power BI content - thank you everyone for interacting with this newsletter in one way or another.
What better way to mark the 50th edition but with the new Power BI Desktop (March 2020) Feature Summary, where we've been told about new action types for buttons, multi-column sort in tables, and many other updates. Also announced was the new, revamped search experience in the Power BI service, making it that little bit easier to find the content you're after.
Other updates this week (from the Azure side) consist of the reminder to Upgrade the TLS version of your Power BI application to TLS 1.2, and the announcement that Azure Stream Analytics managed identity authentication to Power BI is now available.
Also marking the 50th edition is my very first blog contribution to the Power BI Weekly newsletter! About time. This week, I've written about Power BI Data Type Mappings, as it can often be confusing knowing how the different data types across the different Power BI mediums correspond to each other. Also from endjin this week - James has continued his blog series about Azure Analysis Services, writing about How to execute a DAX query from .NET.
Elsewhere this week, Daniil Maslyuk has provided a nifty workaround to have the card title in a multi-row card render properly, and Paul Turley has shared a report to monitor COVID-19 Coronavirus Daily Updates.
🛠️ Data Prep
- Ben Gribaudo (@bgribaudo) discusses Power Query Security: Evidence Left Behind
- On the Power BI community blog, Jordan Sanders describes How to Connect to an ODBC Data Source From Power BI
- On the Blue Granite blog, Ryan Wade explains How to Enrich Power BI with Pre-Built Sentiment Analysis Models
- On the CSG Pro blog, Kirill Perian (@kirillperian) talks about Untangling Nested Headers in Power Query
🧩 Data Modeling
- Chris Webb (@cwebb_bi) talks about Making One Power BI Measure Appear In Multiple Folders
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) discusses The COALESCE function in DAX
- Patrick Leblanc (@GuyInACube) explains how to Configure Power BI Aggregations
- Also on the Power BI community blog, artemus discusses Custom Aggregations in Group By
- Chandeep Chhabra (@chandeep2786) explains how to Calculate SAMEPERIODLASTYEAR for Partial Year and writes about Calculate Cost Amortized Till Date – DAX CHALLENGE
- On the MSSQLTips site, Aveek Das (@avikoleum) writes about Cumulative Sales by Week of Quarter in Power BI
- Matt Allington (@ExceleratorBI) writes about Adding Semesters to a Calendar in Power BI
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a number of blogs: Creating Virtual Relationships In Power BI Using The TREATAS Function, Check Out Our Re-Imagined DAX Formula Reference Guide, Attrition Analysis: Finding Lost Customers Using Power BI & DAX, Analyze Profit Margin Changes Overtime – Analytics with Power BI and DAX, How To Use The CROSSJOIN Function – Power BI & DAX Tutorial, Showing Cumulative Results vs Targets Only To Last Sales Date in Power BI, Power BI Financial Reporting: Allocating Results To Templates At Every Single Row, Forecasting Product Demand Using Power BI Analysis Techniques and on the Power BI community blog, Unique Ranking Insights in Power BI Using RANKX & TOPN
- Bill Anton (@SQLbyoBI) writes about Power BI Time-Intelligence: Beyond the Basics
- On the endjin blog, James Broome talks about Azure Analysis Services: How to execute a DAX query from .NET
- Greg Low (@greglow) blogs about BI: FIX Failed to save modifications to the server. Error returned – The key didn't match any rows in the table
⚙️ Report Design and Visualizations
- On the BI Elite blog, Parker Stevens (@PowerBIElite) writes about Dual Axis Line Charts in Power BI
- Soheil Bakhshi (@biinsightnz) describes How to Sort Matrix by Column in Descending Order
- Lars Schreiber (@SchreiberLars) presents a Podcast – Power BI report design best practises
- On the Visual BI blog, Bhupinder Singh talks about the xViz Waterfall Chart : Addressing frequently asked features from Power BI Ideas place
- On the CSG Pro blog, Robin Abramson talks about Dynamic Columns for Dynamic Visualizations in Power BI
- Daniil Maslyuk (@DMaslyuk) talks about Using text measures in multi-row cards in Power BI
- On the Power BI Community blog, Timo Riikonen (@TimoRii) provides an End-to-End Example for Adding Icons to Your Power BI Report
⚙️ Data Exploration
- Marc Lelijveld (@MarcLelijveld) blogs about Power BI drill through, powerful, but hard to find, Until now
- Patrick Leblanc (@GuyInACube) describes Controlling Power BI drill down with a few tricks
- Ignacio Barrau (@ignacho_07) writes about Power Bi en Tiempo Real - Lote con pandas [Spanish]
🚀 Deployment, Security and Operations
- Kevin Feasel and Eugene Meidinger present Episode 193: Power BI Premium
- Chris Webb (@cwebb_bi) covers Visualising Power BI Premium And Azure Analysis Services Query Parallelism
- On the Prologika blog, Teo Lachev (@tlachev) talks about Power BI Embedded, Service Principals, and AAS
- Marc Lelijveld (@MarcLelijveld) describes how to Monitor your On-premises data gateway with Azure and Power BI – Part 1 – Gateway up-time
- Gilbert Quevauvilliers (@GilbertQue) describes How to configure Incremental Refreshing in Power BI with DateKey or Date instead of the default DateTime
- On the CSG Pro blog, Gavin McLaughlin (@GavinCSGPro) writes about What You Need to Know About Power BI Embedded (With Examples)
- James Serra (@JamesSerra) talks about Power BI Security
- Marcus Wegener (@PowerBIler) writes about Windows-Anmeldeinformationen für Webproxyauthentifizierung in Power BI Desktop verwenden [German]
- On the DataAP blog, Hariharan Rajendran (@imhariharanr) describes how to get Power BI Report Subscription as PDF
🌐 General
- On the Power BI blog, Nikhil Gaekwad (@NikhilGaekwad) announces a new, revamped search experience in the Power BI service
- Also on the Power BI blog, Sujata Narayana shares the Power BI Desktop March 2020 Feature Summary
- Rafael Mendonça (@rafaelmpsantos) writes about the Atualização MARÇO 2020 [Portuguese]
- Alexander Arvidsson (@arcticdba) and Toni Holopainen (@MrBlackSwe) present Podcast episode 109
- On the endjin blog, Ed Freeman (@edfreeman_) writes about Power BI Data Type Mappings
- The Azure updates team shares a few updates: Upgrade the TLS version of your Power BI application to TLS 1.2, Azure Analysis Services—Preparing for transport layer security 1.2 and Azure Stream Analytics managed identity authentication to Power BI is now available
- Adam Saxton (@GuyInACube) talks about Power Platform help for Coronavirus and more... (Roundup | March 9, 2020)
- Paul Turley (@paul_turley) shares COVID-19 Coronavirus Daily Updates in Power BI
- Also on the Power BI blog, Sandy Rivas (@SandyRivas) shares the February 2020 Community Highlights
- Lars Schreiber (@SchreiberLars) presents the podcast: Was ist Power BI Desktop? [German]