Power BI Weekly Issue 197: 7th March 2023
There has been a handful of announcements this week, from features turning GA to improvements in the Power BI compute engine. Let's start with the GA: Power BI Org Apps with Multiple Audiences now Generally Available, the Power BI integration with is now generally available, and the General availability of Power BI with Azure Database for MySQL - Flexible Server. The other announcements this week are as follows: there's new Query parallelization functionality to boost Power BI dataset performance in DirectQuery mode, we've been told that Multi-tasking in Microsoft Teams with Power BI is getting better (largely down to UX enhancements), and we've been given the Power BI Datamart – February 2023 Feature Summary, including the ability to manage the default dataset to add/remove tables from the autogenerated dataset.
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!)
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.