Power BI Weekly Newsletter Issue #132

powered by endjin

If you have any content you'd like to contribute to the newsletter, please tweet @PowerBIWeekly or ping an email to PowerBIWeekly@endjin.com.

Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news.

@edfreeman_ | @endjin
powerbiweekly.info | endjin.com

Data Prep

Covering: Power Query (M), Dataflows, Data connectors, AI Insights

• 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

Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models

• 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

Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards

• 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

Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling

• 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

Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs

• 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)

Useful Links

• Azure Weekly - Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news
• M language reference - Official Power Query M Reference
• DAX Studio - Useful open source tool for executing and analyzing DAX queries, founded by Darren Gosbell
• DAX Guide - Your go-to reference on the DAX language, created by the SQLBI team
• Power BI Visuals Reference - An exhaustive list (as of Sep. 2018) of all Power BI native & custom visuals, placed into separate categories, again created by the SQLBI team
• Report Theme Generator - A handy report theme generator created by the Power BI Tips and Tricks team
• Power BI Theme templates - Detailed Power BI Theme templates for all the native visuals, created by David Eldersveld
• Power BI from Rookie to Rock Star - Free, detailed eBook to get up and running with Power BI, written by Reza Rad
• Power BI Architecture diagram - An informative Power BI Architecture diagram, created by Dustin Ryan
• Power BI Whitepapers - A list of official Power BI whitepapers, covering Security, Premium deployment, Advanced Analytics and more
• Power BI Events - Interactive report displaying upcoming Power BI events worldwide, built by Matt Allington, Phil Seamark and Reid Havens
• Power BI Days - Free-to-attend virtual and in-person community events, all across the world. If you're wanting to organize an event, that's possible too - it's still free, and comes with support.