Power BI Weekly Issue 150: 29th March 2022
Surprise suprise - Microsoft has (again) been named a Leader in the 2022 Gartner® Magic Quadrant™ for Analytics and BI Platforms, out there furthest to the top-right corner. To each their own, but no one can deny that this is a pretty impressive feat from the Power BI team. Other than that, there are no official announcements in this week's newsletter. However, following the release of the March 2022 Power BI update, there have been plenty of great articles across the community this week. James Andrew has given some handy tips about How to Create and Effectively Use Error Bars within Power BI, Bas Dohmen has shown how to add a target area to a line chart using error bars, and the folks at Learning Science have walked through the two new powerful capabilities of the Azure Maps visual: Geocoding and Pie Chart Layers.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes Query Editor In Power BI | An Overview
- Chandeep Chhabra (@chandeep2786) explains how to Duplicate Rows in Power Query
- Imke Feldmann (@TheBIccountant) describes how to Fill values to the right in Power Query and Power BI
- On the Perficient blog, Rushabh Ganar (@Perficient) describes Creating & Invoking Custom Function in Power Query
- On the MSSQLTips site, Kenneth A. Omorodion describes how to Incrementally Refresh Data in Power BI with Power Query for Integer Date Fields
- George Mount (@_EnterpriseDNA) describes How To Filter Data Using Anti Join In Excel With Power Query
- Ben Gribaudo (@bgribaudo) discusses Power Query M Primer (Part 24): Query Folding II
- Delia Fernandez (@datachant) blogs about Authoring a Power BI Dataflows Solution
- On the Prologika blog, Teo Lachev (@tlachev) writes about 5 Storage Gotchas for Power BI Dataflows
- On the Learning Science YouTube channel, Learning Science talks about Power BI Data Connectivity Modes
- George Mount (@_EnterpriseDNA) describes DPLYR & Friends For Power BI Users
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes how to Import Web pages with Power BI
- Meagan Longoria (@mmarie) walks through Calling the Intercom API with Power Query and Refreshing in the Power BI Service
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about STDEV.P, STDEV.S, STDEVX.P, STDEVX.S – DAX Guide and describes ISEVEN, ISODD – DAX Guide
- Urish Arora (@urisharora) blogs about Power BI – Time Intelligence Functions and explains How To Use DAX LOOKUPVALUE() Function in Power BI
- On the Power BI community blog, Jay Wang blogs about Custom Fiscal Week
- On the Enterprise DNA blog, Antriksh Sharma (@_EnterpriseDNA) describes How To Install DAX Studio & Tabular Editor In Power BI
- Reid Havens (@HavensBI) presents DAX Debugger Walkthrough in Tabular Editor 3 - with Daniel Otykier
- Antriksh Sharma (@_EnterpriseDNA) covers Getting started with Aggregations in Power BI - Part 1
- Mimoune Djouallah (@mim_djo) describes How Power BI Composite Model Works
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) describes Hybrid tables in Power BI: Extending beyond time-related scenarios
- Shabnam Watson (@ShbWatson) describes Hybrid Tables (In Power BI) Q&A
- Hima Bindu Marri (@sivahimabindu) describes Bidirectional cross filtering in Power BI | Power BI Interview questions
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Reid Havens (@HavensBI) discusses Visual Formulas Vs DAX - Making a Case for InfoRiver (with Marco Russo as Moderator)
- Philipp Lenz (@lenz_philipp) writes about Dynamic Design Theming of Power BI Embedded Reports
- Bas Dohmen (@HowToPowerBI) describes how to Add a Target Area in an Easy Way
- On the Learning Science YouTube channel, Learning Science talks about Azure Maps Power BI - March 2022 Update | Maps in Power BI
- On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) discusses URL Links in Power BI
- James Andrew explains How to Create and Effectively Use Error Bars within Power BI | New March 2022 Feature
- Ruth Pozuelo Martinez (@CurbalEN) explains How to create and interprete error bars in Power BI and discusses Images won't load in Power BI? Here is why and how to fix it
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Microsoft BI Tools blog, Joost van Rossum (@ssisjoost) explains how to Refresh Power BI Datasets with ADF or Synapse
- Gilbert Quevauvilliers (@GilbertQue) discusses Which Power BI Reports do I have access to? Part 1: Using the Power BI Scanner to get App Workspace data
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, Kim Manis (@kimmanis) shares Microsoft named a Leader in the 2022 Gartner® Magic Quadrant™ for Analytics and BI Platforms
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 222 - Power BI March 2022 Feature Summary
- Adam Saxton (@GuyInACube) presents Who doesn't like free Power BI training? (2022)
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.