Power BI Weekly Issue 105: 13th April 2021
A few updates this week: Object-Level Security (OLS) is now generally available in Power BI Premium and Pro, there's a new sharing experience coming soon (shareable links), and we've been told about What's New In Dataflows - April 2021 including terminology updates ("entities" are now called "tables", and "fields" are called "columns").
Elsewhere this week, Nikola Ilic has written the final part of a series on Query folding in Power BI - tricks, lies & ultimate performance test, Sam Fischer has described How to reset calculation groups in a custom tooltip or drillthrough page, and Priscilla Camp has shared A quick trick using the Relative Date Filter in Power BI.
Finally, don't forget about the Power BI Summit taking place April 19-23 - lots of your favourite speakers in a jam-packed schedule covering all areas of Power BI.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- On the Power BI blog, Charles Webb (@CharlesWebb22) describes What’s New In Dataflows – April 2021
- Chris Webb (@cwebb_bi) writes about Importing Data From ADLSgen2 Into Power BI: Summary Of Findings
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) covers Query folding in Power BI—tricks, lies & ultimate performance test
- On the CSG Pro blog, Brian Grant (@BrianGrantBI) writes about Combining Conflicting Customer Names Using Power Query and describes Creating a Local ID in Power Query
- On the Power BI community blog, Yingying Ruan blogs about Rows and columns conversion and bulk renaming of columns
- On the Data Bear blog, Mariska Oosthuizen explains how to Add a Custom Column in Power BI
- Jon Acampora (@excelcampus) talks about 15 Shortcuts for Power Query
- Bas Dohmen (@HowToPowerBI) explains how to Convert Your Query into an M Function | Combine Data from Multiple Excel Sheets in Power BI
- Hima Bindu Marri (@sivahimabindu) describes how to Dynamically remove columns Power Query
- Laura Graham-Brown (@Laura_GB) describes Power BI Desktop Connecting to Dataverse
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Computing rolling average in DAX, describes Rolling 12 Months Average in DAX and talks about Solving currency conversion – Unplugged 14
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a few tutorials: CONCATENATE, CONCATENATEX – DAX Guide, EXACT – DAX Guide, FIND – DAX Guide, FIXED – DAX Guide, FORMAT – DAX Guide and LEFT, RIGHT, MID, LEN – DAX Guide
- Patrick Leblanc (@GuyInACube) explores the Power BI Model View
- Sam Fischer (@ApexInsightsPBI) highlights 10 ways you can use Calculation Groups in Power BI and describes How to reset calculation groups in a custom tooltip or drillthrough page
- On the Towards Data Science blog, Salvatore Cagliari writes about A little DISTINCT challenge with DAX optimisation
- On the BI Power blog, Didier Terrien shares the DAX debugger in Power BI Sidetools
- Reid Havens (@HavensBI) talks about Power BI Sidetools - All Kinds of AWESOME with Didier Terrien
- On the CSG Pro blog, Brian Grant (@BrianGrantBI) talks about Time Is On Your Side: An Intro to DAX Time Intelligence
- Ruth Pozuelo Martinez (@CurbalEN) covers DAX Fridays #203: Examples of MAX calculations of groups and subgroups
- Sam McKay (@_EnterpriseDNA) explains how to Calculate Average Per Day / Month / Year In Power BI Using DAX
- Greg Philps talks about Comparing Top N And Average Of Others In Power BI
- Brian Julius writes about Three Types Of Tables In Power BI And Why The Distinctions Matter
- Matthew Peterson (@mattpetersonbi) describes how to Use Switch over IF To Make Life Easier
- On the SQL Shack blog, Rajendra Gupta provides An overview of Power BI data models
- Ben Lawrence & Ahmed Abualsoud talk about Efficiency Improvements in PBI Datasets: What We’ve Learned
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI community blog, Priscilla Camp (@ITDataDiva) provides A quick trick using the Relative Date Filter in Power BI
- On the Prologika blog, Teo Lachev (@tlachev) lists the Top 5 Power BI UX Gaps
- On the Purple Frog Systems blog, Nick Edwards describes How to make your matrix column widths all equal to each other in Power BI using DAX.
- Bas Dohmen (@HowToPowerBI) discusses Custom Formatting in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) writes about 2 Power BI matrix hacks you wish you knew and shares I bet you didn't know at least one of these Power BI hacks
- Paul Lucassen explains How To Create Custom Legend For Power BI Map Visuals
- Bas Dohmen (@HowToPowerBI) covers Status Bar in Power BI
- Dhruvin Shah (@DhruvinShah16) provides an Introduction to Power BI Paginated Reports and shares an Overview of Power BI Report Builder
- Soheil Bakhshi (@biinsightnz) walks through Exporting Power BI Desktop Data Using Power BI Exporter
- Also on the Power BI community blog, AbhiSSRS writes about Power BI Paginated Reports with Custom Code (VB Code)
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, Sujata Narayana highlights the New sharing experience coming soon
- Gilbert Quevauvilliers (@GilbertQue) explains How to complete granular deployment of Power BI Desktop changes to the Power BI Service (Using PPU)
- Reid Havens (@HavensBI) talks about the New & Improved Template App Install Experience
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, Ogbemi Ekwejunor-Etchie writes that Object-Level Security (OLS) is now generally available in Power BI Premium and Pro!
- Also on the Power BI blog, Kelly Kaye (@MS_KellyKaye) explains how to Join us! Power BI Summit April 19-23
- Patrick Leblanc (@GuyInACube) describes Power BI for the NON-TECHnical person
- Adam Saxton (@GuyInACube) shares Power BI tips from the Pros – LIVE w/ Matthew Roche (April 10, 2021)
- On the Power BI community blog, Heather Newman (@heddanewman) writes about User Groups: Get signed up for our Public Preview
- On the MSSQLTips site, Kenneth A. Omorodion blogs about Power BI for Business Intelligence
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 186 - Community News
- The Knee-Deep in Tech team (@KneeDeepinTech) presents Podcast episode 147
- On the Towards Data Science blog, Nathan Cheng writes Minimum Viable Streaming Dashboard in Power BI: Part 3
- Ted Pattison (@TedPattison) describes Developing with Net 5 and App Owns Data Embedding
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.