Power BI Weekly #132 - 9th November 2021
Power BI Weekly Newsletter Issue #132
powered by endjin
Welcome to the 132nd edition of Power BI Weekly! 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.
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.
Tweet | Forward | Preferences | Unsubscribe
Older messages
☁️ Azure Weekly #348 - Ignite 2021 Special! - 7th November 2021
Sunday, November 7, 2021
Azure Weekly Newsletter Issue #348 powered by endjin Welcome to issue 348 of Azure Weekly - an Ignite 2021 special! As ever, a great summary of all things Ignite are covered in the Microsoft Book of
Power BI Weekly #131 - 26th October 2021
Tuesday, October 26, 2021
Power BI Weekly Newsletter Issue #131 powered by endjin Welcome to the 131st edition of Power BI Weekly! Again, a pretty quiet week from Microsoft's side, with the main highlight being the GA of
Power BI Weekly #129 - 12th October 2021
Tuesday, October 12, 2021
Power BI Weekly Newsletter Issue #129 powered by endjin Welcome to the 129th edition of Power BI Weekly! The wait is over... Premium Gen2 is now GA! Take another flick through the docs before pressing
Power BI Weekly #127 - 28th September 2021
Tuesday, September 28, 2021
Power BI Weekly Newsletter Issue #127 powered by endjin Welcome to the 127th edition of Power BI Weekly! This week we've been given the Power BI September 2021 Feature Summary, including nice
Power BI Weekly #125 - 14th September 2021
Tuesday, September 14, 2021
Power BI Weekly Newsletter Issue #125 powered by endjin Welcome to the 125th edition of Power BI Weekly! Just the one announcement on what has been a very quiet week, and that's an update on the
You Might Also Like
Apple RCS 📱, SBF's 25 year sentence 👮, Linux Foundation's Redis fork 👨💻
Friday, March 29, 2024
RCS is coming to the iPhone in the fall of 2024 Sign Up|Advertise|View Online TLDR Together With Veracode TLDR 2024-03-29 Build fast, build secure (Sponsor) Software is drowning in security debt.
Data Science Weekly - Issue 540
Friday, March 29, 2024
Curated news, articles and jobs related to Data Science, AI, & Machine Learning ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
This Week in Rust #540
Friday, March 29, 2024
Email isn't displaying correctly? Read this e-mail on the Web This Week in Rust issue 540 — 27 MAR 2024 Hello and welcome to another issue of This Week in Rust! Rust is a programming language
The Value Of A Promise 🤞
Friday, March 29, 2024
How much is a promise from a tech company really worth, anyway? Here's a version for your browser. Hunting for the end of the long tail • March 28, 2024 The Value Of A Promise When you hear a
New Elastic Security for SIEM Training Course
Friday, March 29, 2024
Detect and respond to evolving threats ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ elastic | Search. Observe. Protect Detect anomalies and malicious behavior March
SBF gets 25 years
Thursday, March 28, 2024
Sam Bankman-Fried is sentenced View this email online in your browser By Christine Hall Thursday, March 28, 2024 Welcome back to TechCrunch PM! The editorial team spent a chunk of the day discussing
💎 Issue 410 - Being laid off in 2023-2024 as an early-career developer
Thursday, March 28, 2024
This week's Awesome Ruby Newsletter Read this email on the Web The Awesome Ruby Newsletter Issue » 410 Release Date Mar 28, 2024 Your weekly report of the most popular Ruby news, articles and
💻 Issue 403 - Microsoft defends .NET 9 features competing with open source ecosystem
Thursday, March 28, 2024
This week's Awesome .NET Weekly Read this email on the Web The Awesome .NET Weekly Issue » 403 Release Date Mar 28, 2024 Your weekly report of the most popular .NET news, articles and projects
💻 Issue 410 - Node.js TSC Confirms: No Intention to Remove npm from Distribution
Thursday, March 28, 2024
This week's Awesome Node.js Weekly Read this email on the Web The Awesome Node.js Weekly Issue » 410 Release Date Mar 28, 2024 Your weekly report of the most popular Node.js news, articles and
💻 Issue 410 - JSDoc as an alternative TypeScript syntax
Thursday, March 28, 2024
This week's Awesome JavaScript Weekly Read this email on the Web The Awesome JavaScript Weekly Issue » 410 Release Date Mar 28, 2024 Your weekly report of the most popular JavaScript news, articles