Power BI Weekly Issue 104: 6th April 2021
In the last week we've been told about some new deployment pipelines capabilities, including support for Paginated Reports and changes to the permissions required to update datasets, amongst various other things. It's also been officially announced that Power BI Premium per user now generally available for purchase - those currently on the trial get to use up the remaining days, but after that you'll need to purchase a proper licence. Otherwise, a couple of bits of content on optimization this week: Patrick Leblanc has discussed the age-old question: Why is Power BI SLOW?, and Antriksh Sharma has given a useful example of How To Optimize Slow Measures In Power BI.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Chris Webb (@cwebb_bi) writes about Partitioned Tables, Power BI And Parquet Files In ADLSgen2
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about What is a Query folding in Power BI and why should I care? and writes about Query folding in Power BI— Devil is in the detail
- On the Access Analytic blog, Wyn Hopkins (@wynhopkins) explains how to Consolidate Multiple Files from a Folder
- On the Power BI community blog, Allan Qin writes about Partial Grouping in Power Query
- Gil Raviv (@gilra) describes Data Quality Automation with Power Query
- On the MSSQLTips site, Kenneth A. Omorodion writes about Common Data Transformations in Power Query
- Chandeep Chhabra (@chandeep2786) describes how to Dynamic Filter by a Range of Values in Power Query
- Bas Dohmen (@HowToPowerBI) explains how to Write Your First CUSTOM M FUNCTION in Power BI
- Mimoune Djouallah (@mim_djo) takes a First Look at BigQuery BI Engine with Power BI
- Darrin Kinney covers Power BI – Resource Profiles from P6
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo & Alberto Ferrari write about Specifying multiple filter conditions in CALCULATE and Marco Russo talks about Exploring Object Level Security in Power BI – Unplugged #13
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a few DAX guide tutorials: Equal to, Strictly equal to, Not equal to – DAX Guide, IN – DAX Guide, Table constructor – DAX Guide, COMBINEVALUES – DAX Guide and Exponentiation – DAX Guide
- On the Power BI community blog, Pragati Jain writes about the CALCULATE Function: March 2021 Power BI DAX Update
- On the PowerPivotPro blog, Mark Beedle (@markbdi) writes Calculation Groups to the Rescue
- On the CSG Pro blog, Ajay Kumar (@BIConsultingPr1) writes about Dynamic Measures, Calculation Groups, and Page Navigation in Power BI
- Matthew Peterson (@mattpetersonbi) blogs about Running Totals Using Variables and Calculate Function
- Ruth Pozuelo Martinez (@CurbalEN) shares DAX Fridays #202: Improve performance of your DAX models
- Reid Havens (@HavensBI) talks about a Fiscal Periods Time Intelligence Slicer in Power BI
- Hima Bindu Marri (@sivahimabindu) talks about Hierarchies in Power BI
- Jarret Moore writes about Multiple Date Functions With VALUES DAX and discusses Using All Vs ALLSELECTED For % Of Totals Measure
- Sam McKay (@_EnterpriseDNA) writes about Dynamic Banding & Segmenting Example In Power BI Using DAX, shares some Advanced DAX Concepts - Webinar and discusses Creating Reports Showcasing Customers With Different Financial Years In Power BI
- Antriksh Sharma describes How To Optimize Slow Measures In Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Paul Turley (@paul_turley) describes how to Drill-through from Power BI to Paginated Report – Report Recipe 4
- On the SQL Server Central blog, Steve Jones (@way0utwest) writes about Power BI Reports in SSMS
- Dhruvin Shah (@DhruvinShah16) describes how to Draw X-Axis Constant Line for Power BI Line Charts
- Patrick Leblanc (@GuyInACube) talks about Why is Power BI SLOW
- Mara Pereira (@datapears) writes Power BI Report Development 101 - Part 1
- Bruno Bossaerts writes about Power BI: Create a Stacked Funnel Chart
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, Nimrod Shalit announces new deployment pipelines capabilities
- Just Blindbæk (@justblindbaek) discusses Extracting Power BI metadata with Data Factory (part 2)
- Bas Dohmen (@HowToPowerBI) talks about Object Level Security in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) talks about a Complete guide to sharing and resuse Power BI data
- Reid Havens (@HavensBI) talks about Paginated Reports & Premium Per User - Beautiful Together with Chris Finlan
- Parker Stevens (@PowerBIElite) blogs about Refreshing a Single Table in a Power BI Dataset via XMLA Endpoint
- Ignacio Barrau (@ignacho_07) writes about the Power BI Gateway - Opciones de interés en puerta de enlace [Spanish]
- On the Power BI Community blog,, Icey Zhang writes that Visualizations cannot display properly in PBI Service with error message
- Shabnam Watson (@ShbWatson) describes How to separate a Power BI file into a Report file and a Model (Dataset) file?
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, Christopher Finlan (@cmfinlan) highlights that Power BI Premium per user now generally available for purchase
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 185 - Power BI News Updates
- Kasper de Jonge (@kjonge) discusses Building a Power BI Center of Excellence with Alex Garcia
- Matt Allington (@ExceleratorBI) shares My Power BI Chat with Ebenezer from Ghana, Africa
- On the Towards Data Science blog, Nathan Cheng writes Minimum Viable Streaming Dashboard in Power BI: Part 2
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (April 3, 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.