Power BI Weekly #182 - 8th November 2022
Power BI Weekly Newsletter Issue #182
powered by endjin
Welcome to the 182nd version of Power BI Weekly! Only a single announcement this week, which is that you can now Save a copy of a report & Collapse navigation pane in Organizational App. The former being a feature that's been brought back by popular demand! Otherwise this week, Microsoft has shown how you can Unleash your Dynamics 365 Data with Azure Synapse Analytics and Power BI (using the Synapse Link capability to replicate your data into a Synapse Analytics environment), the SQLBI team has released the 1.0 version for their Bravo for Power BI tool, and James Andrew has shown a nice way to Use Canva to Create an Interactive Power BI Virtual Assistant.
Finally this week, Eli has shared her Big Data LDN: highlights and how to survive your first data conference, talking a lot about Data Mesh and other key elements of the modern data stack.
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
- Patrick Leblanc (@GuyInACube) discusses The perfect Power BI dataflows use case
- Antriksh Sharma (@AntrikshShar) explains How to make Power Query remember the data types of columns before expanding
- Chandeep Chhabra (@chandeep2786) explains how to Remove Spaces between words in Power Query
- On the Power BI community blog, Yalan Wu blogs about Power Query Common Expression. Error
- Ben Gribaudo (@bgribaudo) covers MySQL's Invalid Dates + Power Query = No Effect Query Folding?
- On the Tessellation Tech blog, Dave Ovitt describes What Are Power BI Datamarts?
- Laura Graham-Brown (@Laura_GB) delves into Power BI – Switch Dataverse Tenancy
- On the Enterprise DNA blog, Gaelim Holland (@_EnterpriseDNA) writes about Python Dataset: Applying Repeatable Codes
- João Marcelino covers Calendário no Power BI [Portuguese]
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes MDX in Power BI tutorial
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo (@marcorus) announces Bravo for Power BI 1.0 released
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) covers SELECTEDMEASURENAME – DAX Guide
- Max Wikström (@maxwiks) covers The purpose of data modeling – Dimensional Modeling and explains how to Find the MIN and MAX value from multiple columns with DAX
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) write about Using DAX To Load Data From SSAS To Power BI
- Brian Julius (@_EnterpriseDNA) explains How To Export All DAX Measures Into A Single File
- Bas Dohmen (@HowToPowerBI) describes Smart Axis Magic | Let Power BI Choose the Optimal Period
- Also on the Power BI community blog, Stephen Tao describes how to Apply AND logic in the slicer
- On Acuity Training, Ben Richardson (@AcuityTraining) describes Speeding Up Power BI
- Sam McKay (@_EnterpriseDNA) walks through In-Depth Customer Churning Examples In Power BI Using DAX [2022 Update]
- Bernat Agulló (@AgulloBernat) describes How to write a C# script for Tabular Editor (Part 1)
- Alina Fisher describes how to Sort Matrix By Selected Columns With RANKX
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI community blog, Fowmy Abdulmuttalib (@ExcelFort) describes how to Toggle Calendar Icon Visibility In Power BI Date Slicer
- Sam McKay (@_EnterpriseDNA) describes How To Use Natural Language Query (Q&A) In Power BI - Detailed Review [2022 Update]
- On the Foresight BI blog, Ahmed Oyelowo (@AhmedOyelowo) covers Power BI Bookmarks Essentials (Part 1)
- Bas Dohmen (@HowToPowerBI) talks about Notification Bell
- James Andrew (@MatadorSoftware) describes how to Use Canva to Create an Interactive Power BI Virtual Assistant
- Gilbert Quevauvilliers (@GilbertQue) describes how to Copy and paste Power BI Visuals in pages between Power BI Desktop Files
- Leila Gharani (@LeilaGharani) describes How to create these useful Power BI visuals we wish Excel had
- Pat Mahoney (@mahoneypa) describes how to Speed up your Power BI visuals with Deneb in-visual calculations
- Reid Havens (@HavensBI) wallks through Creating a Countdown Visual using Deneb (with Daniel Marsh-Patrick) and describes Best Practices for Report Design & DAX in Power BI (with Gustaw Dudek)
- Alina Fisher writes about Range Bars In Power BI 2.0
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, Harleen Kaur describes how to Save a copy of a report & Collapse navigation pane in Organizational App
- Chris Webb (@cwebb_bi) describes how to Speed Up Power BI Dataset Refresh Performance In Premium Or PPU By Changing The “Parallel Loading Of Tables” Setting
- Adam Saxton (@GuyInACube) describes how to Bring Power BI and Excel together
- Shabnam Watson (@ShbWatson) talks about Incremental Refresh and Hybrid Tables in Power BI, writes about Error running a SQL Server Profiler trace for a Power BI dataset: Either the trace with the ID of ‘MicrosoftProfilerTrace1667261566’ does not exist … and describes How does the DirectQuery partition of a Hybrid table in Power BI get used in queries?
- Microsoft Power BI (@MSPowerBI) walk through Cross tenant dataset sharing
- On the RADACAD blog, Reza Rad (@Rad_Reza) discusses Why Do You Need Power BI Service?
- On the MSSQLTips site, Haroon Ashraf writes about Data Masking and Unmasking Strategy for Power BI Report Testers and Business Users
- Alina Fisher shares The Ultimate Security Cheat Sheet In Power BI
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Cillian Mitchell (@MSPowerBI) explains how to Unleash your Dynamics 365 Data with Azure Synapse Analytics and Power BI
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 239 - Power BI News Update
- On the Power BI Tips and Tricks blog, Tommy Puglia (@tommypuglia) announces Welcome to Community Jam
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
Key phrases
Older messages
☁️ Azure Weekly #394 - 6th November 2022
Sunday, November 6, 2022
Azure Weekly Newsletter Issue #394 powered by endjin Welcome to issue 394 of Azure Weekly. There's a mixed bag of interesting content this week. Firstly there's an article about Data mesh: A
👻 Azure Weekly #393 - 30th October 2022
Sunday, October 30, 2022
Azure Weekly Newsletter Issue #393 powered by endjin Welcome to issue 393 of Azure Weekly! To start with, there's a podcast featuring Isaac Abraham talking about Farmer for Azure Deployments. We
Power BI Weekly #180 - 24th October 2022
Tuesday, October 25, 2022
Power BI Weekly Newsletter Issue #180 powered by endjin Welcome to the 180th edition of Power BI Weekly! We've been given the Power BI October 2022 Feature Summary this week, and there are a few
☁️ Azure Weekly #391 - 16th October 2022
Sunday, October 16, 2022
Azure Weekly Newsletter Issue #391 powered by endjin Welcome to issue 391 of Azure Weekly! As it's the week of Microsoft Ignite 2022, this edition is somewhat epic in length due to the number of
Power BI Weekly #178 - 11th October 2022
Tuesday, October 11, 2022
Power BI Weekly Newsletter Issue #178 powered by endjin Welcome to the 178th edition of Power BI Weekly! Just the one announcement this week, which is about Deployment pipelines – announcing "
You Might Also Like
💻 Issue 328 - My new open-source repository to schedule all your content!
Thursday, March 28, 2024
This week's Awesome React Weekly Read this email on the Web The Awesome React Weekly Issue » 328 Release Date Mar 28, 2024 Your weekly report of the most popular React news, articles and projects
📱 Issue 407 - Apple just announced WWDC24. The keynote for WWDC24 will be held on Monday, June 10th.
Thursday, March 28, 2024
This week's Awesome Swift Weekly Read this email on the Web The Awesome Swift Weekly Issue » 407 Release Date Mar 28, 2024 Your weekly report of the most popular Swift news, articles and projects
💻 Issue 405 - 2024 Edition Update
Thursday, March 28, 2024
This week's Awesome Rust Weekly Read this email on the Web The Awesome Rust Weekly Issue » 405 Release Date Mar 28, 2024 Your weekly report of the most popular Rust news, articles and projects
🤖 What to Expect From Google I/O 2024 — How to Stop Apps From Leaking Your Data
Thursday, March 28, 2024
Also: The Best Camera Straps of 2024, and More! How-To Geek Logo March 28, 2024 📩 Get expert reviews, the hottest deals, how-to's, breaking news, and more delivered directly to your inbox by
Infographic | How Small Investments Make a Big Impact Over Time 📈
Thursday, March 28, 2024
Compound interest is a powerful force in building wealth. Here's how it impacts even the most modest portfolio over the long term. View Online | Subscribe Presented by: EnergyX's groundbreaking
Fully Autonomous Development, AI .NET Components, Data Visualization ML Tutorial, More
Thursday, March 28, 2024
Home | News | How To | Webcasts | Whitepapers | Advertise .NET Insight March 28, 2024 THIS ISSUE SPONSORED BY: ■ Visual Studio Live! Chicago: .NET Developer Training Conference ■ dtSearch® - INSTANTLY
Daily Coding Problem: Problem #1395 [Hard]
Thursday, March 28, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Google. Implement an LRU (Least Recently Used) cache. It should be able to be
72 x $99 tickets left for virtual product conference (May 2)
Thursday, March 28, 2024
ACT FAST! ONLY 72 TICKETS AVAILABLE AT THE DISCOUNTED RATE OF $99! MAY 2, 2024 | ONLINE ACROSS THE WORLD Join product people from around the world on Thursday, May 2, for INDUSTRY, the #1 Virtual
⚙️ "I'm a GPT builder" 😎
Thursday, March 28, 2024
Plus: Elon's Grok will be available to all
🔒 The Vault Newsletter: March issue 🔑
Thursday, March 28, 2024
Get the latest business security news, updates, and advice from 1Password. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏