Power BI Weekly Newsletter Issue #197

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 sibling 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

• On the Power BI blog, Jacinda Eng (@MSPowerBI) announces Power BI Datamart – February 2023 Feature Summary
• Ben Gribaudo (@bgribaudo) writes about Lazy, Streamed, Immutable: Try Building a Table
• Greg Deckler (@GregDeckler) covers Here Are The Differences Between Connectivity, Dataset and Storage Modes In Power BI
• Patrick Leblanc and Alex Powers (@GuyInACube) talk about Getting Crazy with the Power Query UI
• Chandeep Chhabra (@chandeep2786) walks through an Advanced Power Query Case Study
• Rafael Mendonça (@rafaelmpsantos) covers Como usar o Web.Contents do Power Query: guia completo [Portuguese]
• Vahid Doustimajd (@VahidDoustiM) shares Free Sample Data Sources to Learn and Practice Power BI

Data Modeling

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

• On the Power BI blog, Kay Unkroth (@MSPowerBI) announces Query parallelization helps to boost Power BI dataset performance in DirectQuery mode
• On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) walks through Using calculation groups or many-to-many relationships for time intelligence selection
• Chris Webb (@cwebb_bi) writes about Text Search Performance In Power BI
• Kurt Buhler (@kurtbuhler) shares Snek! The First Video Game for Tabular Editor 3
• Antriksh Sharma (@AntrikshShar) covers Export Measures from Power BI using C#
• On the MSSQLTips site, Jared Westover (@WestoverJared) describes DAX CASE Statement Functionality with IF, SWITCH and SWITCH True
• Sam McKay (@_EnterpriseDNA) describes Break Out Outliers And Analyze Over Time - Advanced DAX Concepts [2023 Update] and explains How To Showcase Deviations Effectively In Power BI [2023 Update]
• Salvatore Cagliari (@TDataScience) covers A better way to get results without data
• Brian Julius (@_EnterpriseDNA) describes How To Use The Performance Analyzer Tool In Power BI To Debug DAX
• On the Enterprise DNA blog, Greg Deckler (@GregDeckler) shares some Tips For A Successful Power BI Implementation

Report Authoring and Interactivity

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

• On the Power BI blog, Maya Shenhav (@MSPowerBI) talks about Power BI and PowerPoint: A Powerful Combination for Data Visualization is now generally available
• Syangprova Sinha discusses Power BI for End Users - GPPB 2023
• On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) covers Power BI Tips Theme Generator: The Ultimate Tool for Creating Complex Themes
• On the Select Distinct blog, Select Distinct (@SelectDistLtd) describe how to Show Values in Rows in Power BI
• Hafeez Jimoh (@jimohhafeezco) covers Data Visualization with Power BI
• Pat Mahoney (@mahoneypa) describes Options to Display Images In Power BI and talks about Options for Simple Linear Regression in Power BI
• Reid Havens (@HavensBI) describes Next Gen Visualizations in Power BI (with Gopal Krishnamurthy), talks about the New Location for Slicer Options in Power BI and describes 5 Ways to Get Power BI Data into Excel (with Wyn Hopkins)
• On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) describe Power BI Excel Integration For P&L Statements
• Gilbert Quevauvilliers (@GilbertQue) writes about Different Power BI Export to table options and what they look like
• Laura Graham-Brown (@Laura_GB) describes how to Export data from Power BI Visuals

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) announces Multi-tasking in Microsoft Teams with Power BI is getting better
• Also on the Power BI blog, Harleen Kaur (@MSPowerBI) writes that Power BI Org Apps with Multiple Audiences now Generally Available
• Adam Saxon and Daniel Glenn (@GuyInACube) talk about The Magic of Microsoft Teams + Power BI
• The Azure Updates Team (@Azure) announces the General availability: Power BI with Azure Database for MySQL - Flexible Server
• On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about Power BI License & Training: A Quick Guide and writes about Challenges (And Opportunities) In Power BI Deployment

General

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

• Sam McKay (@_EnterpriseDNA) presents Driving a Data Culture and Overcoming Challenges as a Power BI Sherpa with Thomas Martens
• On Acuity Training, Ben Richardson (@AcuityTraining) provides an Introduction to Power BI (Crash Course!)

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