Power BI Weekly Issue 106: 20th April 2021
Hope those attending the Power BI Summit are enjoying themselves so far. This week we've been given the Power BI April 2021 Feature Summary, where a couple of the main announcements are about the new Power Automate visual for Power BI reports, allowing you to act on the insights you find when exploring a Power BI report in a contextual manner, and the new Charticulator visual letting you create your custom visuals right from within Power BI. Both visuals are in preview.
Elsewhere this week, Alberto Ferrari has written a thorough technical blog on the age-old question: Star schema or single table. Gil Raviv has shared the New App: Dataflow Snapshots Analysis, helping you compare different Dataflow snapshots between refreshes. And Alex Jankowski has described Building a SelectQuery Function in Power Query, helping dynamically select an M query given an input selection.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Chris Webb (@cwebb_bi) discusses Power BI Dataflow Performance, Premium Per User And The Enhanced Compute Engine
- On the DAX Pro Services blog, Jesus Gonzalez writes about a Naming convention for Power Query steps
- Belinda Allen (@MsBelindaAllen) discusses Referencing a Query in the Query Editor and talks about Removing Duplicate Records in the Query Editor
- Mike Allen (@MikeAinOz) writes about Planner Data in Power BI
- On the Excelguru blog, Alex Jankowski walks through Building a SelectQuery Function in Power Query
- On the Purple Frog Systems blog, Jon Fletcher blogs about Power BI – Enable Load
- Brian Julius discusses Incorporating M In Custom Column
- On the Towards Data Science blog, Patrick Pichler describes Driving Insights at Scale Using a Common Data Model CDM on Azure Data Lake
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) delves into Power BI – Star schema or single table
- On the SQLBI blog, Marco Russo (@marcorus) talks about Increasing compression in Power BI and Analysis Services – Unplugged #15
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a few tutorials: LEFT, RIGHT, MID, LEN – DAX Guide, LOWER, UPPER – DAX Guide, REPLACE – DAX Guide, REPT – DAX Guide, SEARCH – DAX Guide and SUBSTITUTE – DAX Guide
- Chandeep Chhabra (@chandeep2786) blogs about Understanding the DAX Filter Function
- On the SQL Shack blog, Rajendra Gupta writes about Azure Analysis Services and Power BI Live connections
- Ruth Pozuelo Martinez (@CurbalEN) shares DAX Fridays #204: Slice by the results of a measure
- Pat Mahoney (@HoosierBi) writes about No Sort Date Tables
- Greg Philps explains How To Create Multilingual Power BI Reports
- Reid Havens (@HavensBI) talks about Relationship Issues With DateTime Data Types in Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI blog, Roseanne Levasseur announces Announcing the new Charticulator visual (Public Preview)
- Also on the Power BI blog, Sujata Narayana announces the new Power Automate visual for Power BI reports
- Daniel Marsh-Patrick (@the_d_mp) highlights that Deneb Now Available for Public Preview
- Marc Lelijveld (@MarcLelijveld) describes how to Jump from one Power BI report to another by using cross-report drill through
- Adam Saxton (@GuyInACube) describes Mastering Power BI Bookmarks
- Mara Pereira (@datapears) describes Data Storytelling in Power BI - Bar Charts
- Bas Dohmen (@HowToPowerBI) describes how to Switch between percentage and absolute values in one visual | Calculation Groups in Power BI
- Hima Bindu Marri (@sivahimabindu) describes how to Show all Categories in a visualization in Power BI
- Belinda Allen (@MsBelindaAllen) walks through Creating a Template Page for Consistency in Microsoft Power BI
- Dhruvin Shah (@DhruvinShah16) discusses Power BI Paginated Report Series - 02: Overview of Power BI Report Builder
- Jarret Moore describes Using The New Field List In Power BI Desktop and writes about the Newly Released Charticulator Visual In Power BI
- Bas Dohmen (@HowToPowerBI) talks about Charticulator in Power BI
- On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) writes Comment produire un état des résultats dans Power BI? [French]
- On Qiita, Yugo Shimizu (@yugoes1021) writes about the Power Automate visual for Power BI report を試してみた [Japanese]
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Philipp Lenz (@lenz_philipp) writes about Multiple Row Level Security Roles and Object Level Security?
- On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) blogs about Power BI issues with switching tenants
- On the CSG Pro blog, Ferenc Csonka (@ferenc_csonka) talks about the XMLA Read-Write Endpoint: The Cornerstone for Power BI as an Enterprise BI Solution
- Also on the CSG Pro blog, Ajay Kumar (@BIConsultingPr1) explains How to Use Data Sensitivity Labels in Power BI
- Gilbert Quevauvilliers (@GilbertQue) describes How to update or create a measure to Power BI Premium Per user without having to publish entire dataset
- Gil Raviv (@gilra) highlights the New App: Dataflow Snapshots Analysis and blogs about Snapshot analysis for your Power Apps Analytical Dataflows
- Laxmi Arte (@ClaritiData) explains how to Add Power BI reports to Microsoft Teams
- Sam McKay (@_EnterpriseDNA) explains how to Immerse In Data Insights Using Power BI Within Microsoft Teams
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, Jeroen ter Heerdt (@jeroenterheerdt) describes Power BI April 2021 Feature Summary
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) presents Episode 187 - Interview with Stephanie Bruno
- Kasper de Jonge (@kjonge) describes The rise and history of Power BI with Amir Netz
- Michael explains how to Automate Building a Power BI Report from Survey Results
- Adam Saxton and Patrick Leblanc (@GuyInACube) explains how to Let’s continue the big data discussion with SQLBI (April 17, 2021)
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.