Power BI Weekly
Issue #55 - 21st April 2020
Last week the 'new look' of workspaces in the Power BI service was rolled out across all regions. What do people think of it? I'm struggling to get used to it, personally, but maybe that will come with time. We've also been told about the ability to Copy a Visual as an Image in reports and dashboards, which I'm sure many of you will find very useful! The Power BI team has also written April update on What's new and what's next for Paginated Reports.
In AAS land, a bunch of features have become GA:
- Many-to-many relationships now GA
- Query interleaving now GA
- Improved query replica synchronization now GA
- Calculation groups now GA
From endjin this week, Carmel has written about Table Functions in DAX, and James has described how to save money with automatic shutdown in AAS. Elsewhere, Chris Webb and Imke Feldmann have written two similar blogs about handling data that may quickly become unavailable in a data source: Keep The Existing Data In Your Power BI Dataset And Add New Data To It Using Incremental Refreshand Create a load history or stage in CDS instead of incremental load in Power BI.
🛠️ Data Prep
- The SQL Data Partners podcast team (@sqldatapartners) presents Episode 197: Power Query in Power BI
- Ben Gribaudo (@bgribaudo) introduces Introducing Data Mashup Cmdlets and writes about The Navigation Step's Name
- On the Forsight BI blog, Akeem Hussain writes about Hidden Power Query Keyboard Shortcuts & Functionalities
- Laura Graham-Brown (@Laura_GB) writes about Power Query – Replace values for whole table
- Imke Feldmann (@TheBIccountant) explains how to Create a load history or stage in CDS instead of incremental load in Power BI
🧩 Data Modeling
- On the endjin blog, Carmel Eve (@carmel_eve) writes about Learning DAX and Power BI – Table Functions
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Working below a DAX formulas granularity
- On the Power BI community blog, Vivek Ranjan talks about The (ALL, ALLSELECTED & ALLEXCEPT) Code
- Patrick Leblanc (@GuyInACube) writes about EASILY create a Hierarchy in Power BI Desktop
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a few blogs: How To Implement Cohort Analysis In Power BI – Advanced DAX Concepts, Comparing Any Sale Versus The Last Sale No Time Intelligence – Advanced DAX In Power BI, CALCULATETABLE DAX Function – Best Practices in Power BI, Measure Branching: Power BI Development Strategy, Power BI Data Model For Advanced Scenario Analysis Using DAX, Format Your DAX Formulas Easily With Our New DAX Clean Up Tool and Power BI Dynamic Ranking By Group
- the Azure updates team shares a few Azure Analysis Services updates: Many-to-many relationships are now generally available, Query interleaving is now generally available, Improved query replica synchronization now available and Calculation groups are now generally available
⚙️ Report Design and Visualizations
- On the BI Elite blog, Parker Stevens (@PowerBIElite) writes about Paginated Report Page Tooltips in Power BI
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes How To Create Multi Threaded Dynamic Visuals
⚙️ Data Exploration
- Zach Renwick (@zachrenwick) describes Creating Data Alerts in Power BI
- Gilbert Quevauvilliers (@GilbertQue) explains how to Create Trello Reporting using Power BI
- Shabnam Watson (@ShbWatson) shares Slides from my presentation for PASS Women In Technology Virtual Group – 04-16-2020
🚀 Deployment, Security and Operations
- Chris Webb (@cwebb_bi) explains how to Keep The Existing Data In Your Power BI Dataset And Add New Data To It Using Incremental Refresh
- Matt Allington (@ExceleratorBI) describes Loading & Distributing Power BI Apps via AppSource
- Nicky van Vroenhoven (@NickyvV) discusses Installing the PowerShell Power BI Management cmdlets
- On the endjin blog, James Broome writes about Azure Analysis Services – how to save money with automatic shutdown
- On the Towards Data Science blog, Yousry Mohamed writes about Power BI Embedded for mere mortals
🌐 General
- On the Power BI blog, Nikhil Gaekwad (@NikhilGaekwad) introduces the 'new look' of workspaces in the Power BI service
- Also on the Power BI blog, Christopher Finlan (@cmfinlan) talks about What's new and what's next for Paginated Reports in Power BI in April
- Also on the Power BI blog, Maggie Tsang writes Announcing: Copy a Visual as an Image
- Chris Webb (@cwebb_bi) lists Five Mistakes To Avoid When Migrating To Power BI From Another BI Platform
- Patrick Leblanc (@GuyInACube) talks about 3 Favorite Options in Power BI Desktop
- On the Power BI Tips and Tricks blog, Christian Wade (@_christianWade) explains how to Get to know ALM Toolkit
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 141 - C'mon get Appy and Episode 142 - Power BI News updates