Power BI Weekly

Issue #132 - 8th November 2021

It's an Ignite bumper edition this week - with Rupali Jain sharing the main summary blog: Ignite 2021: Enabling data-driven decisions everywhere collaboration happens with enterprise-grade analytics. That blog highlights the announcements such as the new Goals updates and features, the GA of the Power BI app for Microsoft Teams, along with another reminder of the upcoming Hybrid tables support mentioned earlier in the year at MBAS. Not announced in the blog above, but just as exciting, is the Improved Export to Excel and Connected PivotTables, with the former now providing the option to maintain a table's or matrix's layout when exporting data.

Aside from Ignite, a few blogs to improve/refine your filtering knowledge this week. First of all, Mihaly Kavasi has written a Slicers or Filters – Comprehensive Guide to serve as your go-to resource for determining the similarities and differences, Prathy Kamasani has described how to show the number of selected items in a Power BI slicer to better understand how many things are being filtered on your page, and in a similar vein, Patrick Leblanc has shared a video titled What's this Power BI report filtered by? with a handful of techniques for you to decipher exactly what's going on.

🛠️ Data Prep

Reid Havens (@HavensBI) blogs about The Possibilities with Power BI & Excel Integration with Chris Webb
Soheil Bakhshi (@biinsightnz) covers Combining X Number of Rows in Power Query for Power BI, Excel and Power Query Online
On the Access Analytic blog, Wyn Hopkins (@wynhopkins) describes how to Insert Blank Rows with Power Query
On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) describes Comparing Tables In Power Query Power BI Tutorial
On the Power BI community blog, Alexis Olson describes how to Select Distinct Rows Ordered by Another Column -- Power Query Edition
Also on the Power BI community blog, smpa01 talks about Combinatorics in Power Query -part1
On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) describes Tips for Using The Power Query Advanced Editor
Rick de Groot (@Rickmaurinus) discusses Lists in Power Query – The Complete Guide
Ruth Pozuelo Martinez (@CurbalEN) describes how to Easily get data from Unicef, OECD and many more without API knowledge | SDMX connector Power BI
On the Tessellation Tech blog, Gavin Pedersen explains How to Create a Date Table from Scratch in Power BI
Bibin Bastian (@bibinbastian) writes about Metadata reporting from Sharepoint Document Library
Bas Dohmen (@HowToPowerBI) explains how to Connect to OneDrive and Sharepoint in Power BI
On the Blue Granite blog, Josh Crittenden (@Jcrit44) talks about Creating Efficient Power BI Datasets Over Snowflake

🧩 Data Modeling

On the Power BI blog, Ikechukwu Edeagu writes about Better Decision-Making with Improved Export to Excel and Connected PivotTables
Chris Webb (@cwebb_bi) writes about Understanding The “The operation was cancelled because of locking conflicts” Error In Power BI
On the Enterprise DNA blog, Antriksh Sharma (@AntrikshShar) shares a few blogs: Tabular Data Editor Preview Data Option, Diagram View In Tabular Editor 3 and Tabular Editor 3 – A Productivity Tool For Power BI
On the MSSQLTips site, Kenneth A. Omorodion writes about the Power BI CONCATENATE Function: How and When to Use it
On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares SWITCH – DAX Guide, COALESCE – DAX Guide and IFERROR – DAX Guide
On the Towards Data Science blog, Nikola Ilic (@DataMozart) talks about Auto Page Refresh in Power BI—Everything you need to know
Also on the Towards Data Science blog, Salvatore Cagliari writes about Why do we have four levels of security in Power BI?
On the CSG Pro blog, Angela Henry (@SQLSwimmer) presents Understanding DAX – It's All About the Context
Bas Dohmen (@HowToPowerBI) discusses a UTC and Daylight Saving Time fix
Ruth Pozuelo Martinez (@CurbalEN) describes how to Troubleshoot DAX quickly with this shortcut Shorts and shares DAX Fridays #213 : Year-to-date Same period previous years in one measure
Chandeep Chhabra (@chandeep2786) writes about Awesome Features of Tabular Editor 3 and describes how to Clean your POWER BI Model – Really Fast
On the Power BI community blog, Fowmy Abdulmuttalib (@ExcelFort) explains how to Create Dates Table Template In Tabular Editor And Add To Any Power BI File With One Click
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) shares a Power BI Pattern | Find Start and End Date of Task from Children
Reid Havens (@HavensBI) describes How to Aggregate Large Datasets in Power BI with Tristan Malherbe
Brian Julius explains How To Dynamically Compare First N Business Days In Power BI and shares First N Business Days Revisited - DAX Solution And Dynamic Titles
On LaDataWeb, Ignacio Barrau (@ignacho_07) writes about CrossFilter y UseRelationship [Spanish]

📊 Report Authoring and Interactivity

On the Power BI blog, Patrick Baumgartner (@patbaum) describes how to More easily integrate goals into all your business processes
Matt Allington (@ExceleratorBI) explains how to Build a Power BI P&L in 5 Mins with InfoRiver
Patrick Leblanc (@GuyInACube) talks about What's this Power BI report filtered by? and explains how to Create a Popup Window in Power BI
Prathy Kamasani (@pkamasani) discusses Showing the number of selected items in a Power BI slicer
Mihaly Kavasi covers Slicers or Filters – Comprehensive Guide
Bernat Agulló (@AgulloBernat) describes A dynamic color gradient for values and totals
Bas Dohmen (@HowToPowerBI) describes Row by row color scale in a matrix in Power BI, talks about Multiple Forecasts in Power BI and shares a Transparency Trick in Power BI
Reid Havens (@HavensBI) talks about Adding Custom SVG Icon Hover Effects in a Single Button
Sam McKay (@_EnterpriseDNA) talks about Geospatial Analytics - Power BI Freestyle Session
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) presents a Power BI Calendar Visual
Brian Julius explains How To Build A Scrolling KPI Ticker In Your Power BI Report
Chris Webb (@cwebb_bi) discusses Is Power BI’s “Show Data Point As A Table” Feature A Security Hole?
On the Power BI community blog, Janey Guo explains How to get access to Microsoft 365 usage analytics to develop a custom report in Power BI Desktop
Mudassir Ali talks about Different Bar Charts That You Can Use To Elevate Your Power BI Report
Gamuchirai B Perekwa (@gamuperekwa) writes about Distance Driven Analysis in Power BI

🚀 Deployment, Security and Operations

On the Power BI blog, Lukasz Pawlowski (@lukasztweets) explains how to Create a more Data Driven Collaboration with the Power BI app for Microsoft Teams (GA)
Adam Saxton (@GuyInACube) presents The Power BI Premium video you need to watch… probably (Oct 2021)
Gilbert Quevauvilliers (@GilbertQue) shares some Steps on how I backed up my Power BI Premium Per User / Premium Database
Marc Lelijveld (@MarcLelijveld) explains how to Automate Power BI single table refresh using Azure Data Factory and Azure Automation
Matt Allington (@ExceleratorBI) writes about Affordable Power BI Premium Using PowerBIShare.com
Denis Selimovic (@DenSelimovic) discusses Power BI Premium Gen2 is here – everything you need to know about it
On the Purple Frog Systems blog, Alex Whittles (@PurpleFrogAlex) describes how to Change the Compatibility Level of a Power BI report
Ted Pattison (@TedPattison) presents Power BI Dev Camp Session 15 - Learn ALM in Power BI with Deployment Pipelines
Hafeez Jimoh (@jimohhafeezco) describes how to Fix sign up issue in Power BI now without a work email address | Use Power BI for free

🌐 General

On the Power BI blog, Rupali Jain (@trulyRu) writes about Ignite 2021: Enabling data-driven decisions everywhere collaboration happens with enterprise-grade analytics
John White and Jason Himmelstein (@bifocalshow) share Episode 209 - Real chat about Microsoft Ignite Fall 2021 and Episode 210 - Power BI News Update 210 - Microsoft Ignite Fall 2021 News
The Power BI team (@MSPowerBI) shares the Power BI Women Summit
Adam Saxton and Patrick Leblanc (@GuyInACube) share Power BI tips from the Pros – LIVE (October 30, 2021)