Power BI Weekly
Issue #57 - 5th May 2020
There have been a number of announcements in the last week. Firstly, Power BI lineage view is now GA, and dataset impact analysis has been introduced, Subreports are now available for Paginated Reports, and link previews for Power BI are coming to Microsoft Teams (but it might take a few weeks to get to your tenant, so be patient). We've also been told about Some important updates to our monthly release cadence for April and May 2020 which it's worth taking a look at.
In other news this week, Prathy Kamasani has described the Progressive disclosure design approach in Power BI using Card pattern, Chris Barber has written about Column-Level Security - 2 Methods for Restricting Column-Level Information, and Jon Acampora has written about 4 Ways to Fix Date Errors in Power Query + Locale & Regional Settings.
Finally, Rishi Sapra and Naveen Ganpat have created a set of quizzes for the DA-100 exam on their Learn Data Insights site, which also includes a number of other helpful resources for other data analytics tools. Elsewhere, Rishi, Naveen and Chris Barber have created a "Power Platform Finance" community, with fortnightly webinars discussing financial reporting & analytics using the Microsoft Power Platform. Do go and check it out!
🛠️ Data Prep
- Erik Svensen (@donsvensen) describes Using SQL scalar value functions in PowerQuery
- Jon Acampora (@excelcampus) writes about 4 Ways to Fix Date Errors in Power Query + Locale & Regional Settings
- On the Excelguru blog, Ken Puls (@kpuls) describes how to Change Multiple Load Destinations at Once
- Imke Feldmann (@TheBIccountant) describes how to Automatically detect and change the types of all columns at once in Power Query
- Spencer Baucke (@JSBaucke) blogs about Web Scraping in Power BI
- Ben Gribaudo (@bgribaudo) highlights that the Data Mashup Explorer 0.2.0-beta & Data Mashup Cmdlets 0.1.2-alpha Released
🧩 Data Modeling
- On the endjin blog, Carmel Eve (@carmel_eve) talks about Data modelling with Power BI – Loading and shaping data and writes Learning DAX and Power BI – CALCULATE
- Also on the endjin blog, James Broome blogs about Testing Power BI reports using SpecFlow and .NET
- On the Power BI community blog, Greg Deckler (@GregDeckler) provides an Excel to DAX Translation and writes Soapbox Series: Adding No VALUE(S)
- Kasper de Jonge (@kjonge) explains how to Debug Power BI aggregations with DAX Studio
- Also on the Power BI community blog, Amit Chandak (@amitchandak78) writes that Week Is Not So Weak: WTD, Last WTD, and This Week vs Last Week
- Also on the Power BI community blog, Chris Barber discusses Column-Level Security - 2 Methods for Restricting Column-Level Information
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) discusses Applying color banding by document number in Power BI
- Chandeep Chhabra (@chandeep2786) explains how to Calculate Fiscal Week in Power BI
- Gilbert Quevauvilliers (@GilbertQue) explains How to create and use Calculation Groups in Power BI Premium / Azure Analysis Services / SQL Server Analysis Services 2019
- On YouTube, Ana María Bisbé York (@ambynet) talks about Modeling scenarios in DAX: The awesome language of Power BI
- Patrick Leblanc (@GuyInACube) explains how to STOP refreshing a single table at a time Power BI Desktop
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a number of blogs: How to Maximize The Use of INTERSECT Function – Advanced DAX, How To Use Iterating Functions To Fix Total Issues In Power BI – DAX Concepts, Advanced Product Budgeting – Actual Results To Budgets Per Product, Showcasing Budgets In Power BI – DAX Cumulative Totals, Projecting The Current Trend in Your Power BI and How To Create Budgets With Seasonality Impact Using Power BI
⚙️ Report Design and Visualizations
- Prathy Kamasani (@pkamasani) blogs about Power BI Reports Landing Page Tips and Tricks: Progressive disclosure design approach in Power BI using Card pattern
- On the CSG Pro blog, Reid Havens (@HavensBI) talks about Unlocking New Visualizations and Features in Power BI (Version 2)
- On the xViz blog, Balasubramaniyan Murugappa announces that xViz Launches Unlimited Free Desktop Alignment Microsoft Power BI
- Matt Allington (@ExceleratorBI) explains how to Build a P&L With Power BI
- Also on the CSG Pro blog, Gregory Petrossian talks about Budgeting and Forecasting in Power BI
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) explains how to Create Reports In Power BI To Show Deviations And Insights and provides some Tips For Power BI Report Design – Best Practices
⚙️ Data Exploration
- Zach Renwick (@zachrenwick) covers Enabling Self-Serve Analytics with Q&A in Power BI
- On the Power BI community blog, ShaktiBI describes a Custom Date Range on Date Slicer Using Power BI JavaScript Library
- Gil Raviv (@gilra) writes about a COVID-19 dashboard in Power BI: What-If
- On the CSG Pro blog, Paul Turley (@paul_turley) provides a COVID-19 Daily Updates Report Development Walkthrough
🚀 Deployment, Security and Operations
- On the Power BI blog, Yaron Canari (@YaronCanari) announces Power BI lineage view GA, and introducing dataset impact analysis
- Adam Saxton (@GuyInACube) covers Power BI DirectQuery and SQL Databases: A Conversation with Bob Ward
- Lars Schreiber (@SchreiberLars) shares a Podcast-Template Apps in Power BI
- On the Enhansoft blog, Garth Jones explains How to Install a Power BI Report Server as a ConfigMgr Reporting Services Point
- Rafael Mendonça (@rafaelmpsantos) writes Criando LOGs diários de Uso Automaticamente [Portuguese]
🌐 General
- Adam Saxton (@GuyInACube) talks about Power BI case studies, AI for Health and more... (Roundup | April 27, 2020)
- Adam Saxton and Patrick Leblanc (@GuyInACube) share the REPLAY: Power BI May 2020 Hangout
- On the Power BI blog, Will Thompson (@Will_MI77) shares Some important updates to our monthly release cadence for April and May 2020
- Also on the Power BI blog, Christopher Finlan (@cmfinlan) announces that Subreports now available for Paginated Reports in Power BI
- Also on the Power BI blog, Lukasz Pawlowski (@lukasztweets) explains how to Collaborate better with link previews for Power BI in Microsoft Teams (Preview)
- Also on the Power BI blog, Lauren Faber writes about Cerner Corporation: The Importance of a Single Source of Truth
- On YouTube, Michal Foster Heldy talks about Connecting data and insights to real life scenarios using Power BI mobile app
- On the PowerPivotPro blog, Rob Collie (@robcolli3) writes about Agile Reaction to Change: Cleaning Up with Bar Keepers Friend
- On the CSG Pro blog, Gavin McLaughlin (@GavinCSGPro) writes about 5 Common Power BI Adoption Myths Debunked
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 116