Power BI Weekly Issue 169: 9th August 2022
A few announcements this week: ADLS Gen2 and Azure Blob connectors now support SAS token authentication (which has been a long time coming), Analysis Services server properties in Power BI Premium are now in public preview (in particular helping those who are migrating/have migrated from Analysis Services), and The Power BI app is available in Microsoft Teams Mobile (seamlessly transition between Teams and the Power BI app on your phone).
Otherwise, Reza Rad has provided an updated presentation on Power BI Architecture for Multi-Developer scenarios, Brian Julius has described How To Create Your Perfect Power BI Template (a great way to standardize core elements of reports across your org), and the folks at GuyInACube have hosted Marco Russo for an entertaining Power BI Optimization Q&A.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- On the Power BI blog, Nikki Waghani (@NikkiWaghani) announces ADLS Gen2 and Azure Blobs SAS Key Connectivity
- Marc Lelijveld (@MarcLelijveld) writes about What you must know when building Power BI dataflows routing over the on-premises data gateway
- Mimoune Djouallah (@mim_djo) describes Aggregate 100 GB using PowerQuery and DuckDB
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) explores Query Folding in Power Query
- On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) blogs about Power Query Variables 3 Ways
- Hima Bindu Marri (@sivahimabindu) explains how to Combine files in Power BI
- On the Power BI Community blog, Chenwu Zhu describes how to Add date to the new records without changing previous date
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the Power BI blog, Ogbemi Ekwejunor-Etchie highlights that Analysis Services server properties in Power BI Premium are now in public preview
- On the SQLBI blog, Marco Russo & Alberto Ferrari discuss Variables in DAX
- Adam Saxton and Patrick Leblanc (@GuyInACube) present a Power BI Optimization Q&A – LIVE w/ Marco Russo Aug 5, 2022
- On the Enterprise DNA blog, Antriksh Sharma (@AntrikshShar) writes about the DEFINE Keyword In DAX Studio: Overview & Examples
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about A Hidden Little Gem that Can Save Your Power BI Life
- Chandeep Chhabra (@chandeep2786) shares 3 Awesome DAX Tricks to deal with BLANKS
- Harsh Joshi (@_EnterpriseDNA) provides A Deep Dive Into RANKX
- Gilbert Quevauvilliers (@GilbertQue) discusses Creating a group with all values Even if not in the data in Power BI
- On Le CFO Masqué, Kim Leblanc writes about La fonction ISINSCOPE et la hiérarchie des données [French]
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Adam Saxton (@GuyInACube) presents Here's a BANANAS report design idea
- Brian Julius (@_EnterpriseDNA) explains How To Create Your Perfect Power BI Template
- On the Power BI community blog, Matt Kocak describes how to Turn your cards into slicers with the Slicer Button custom visual
- Also on the Power BI community blog, Ray Wu explains how to create Advanced Sport Visualisations in Power BI and writes about a Colour Palette Dropdown Selection to switch between themes.
- Also on the Power BI community blog, Steve de Peijper (@bi2analytics) writes about InteractivePlotly Waterfall Chart in Power BI and describes how to Quickly build a Custom Power BI Visual KPI Card from scratch
- Mara Pereira (@datapears) writes about Creative ways to show filter selections on your Power BI reports
- James Andrew (@MatadorSoftware) describes how to Improve End User Experience with These Simple Power BI Tricks
- Bas Dohmen (@HowToPowerBI) explains how to Enable more Color options | Dynamic gradient in Power BI
- Reid Havens (@HavensBI) discusses Quick Insights & Story Telling Utilizing InfoRiver Advanced Charts with Gopal Krishnamurthy
- Gaelim Holland (@_EnterpriseDNA) describes How To Visualize Correlations In Python And Port Over Into Power BI
- Lars Schreiber (@SchreiberLars) shares Gesetzte Filter im Power BI-Bericht anzeigen [German]
- On the PowerPivotPro blog, Kristi Cantor (@cajuncody) blogs about The case of the disappearing Field Parameters: SOLVED
- Flávio Meneses describes Top 5 Advanced Visualisation Techniques with Flavio Meneses
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, Nikki Waghani (@NikkiWaghani) writes that the On-premises data gateway July 2022 update is now available
- Chris Webb (@cwebb_bi) talks about Calling The Power BI Enhanced Refresh API From Power Automate, Part 1: Creating A Basic Custom Connector
- On the RADACAD blog, Reza Rad (@Rad_Reza) talks about Power BI Architecture for Multi-Developer
- Reid Havens (@HavensBI) describes Certifying Power BI Content with Melissa Coates
- On the Power BI community blog, Ray Wu covers Setting up scheduled refresh - PostgresSQL
- Ignacio Barrau (@ignacho_07) writes about Power BI Integraciones en Outlook y PowerPoint [Spanish]
- On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) describes Apps in Power BI
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, Lukasz Pawlowski (@lukasztweets) explains how to Announcing: The Power BI app is available in Microsoft Teams Mobile
- Microsoft Power BI (@MSPowerBI) covers Power BI Community Show Episode 9 - Datamarts & New Power BI Community Features
- Ruth Pozuelo Martinez (@CurbalEN) talks about 5 key questions to ask before you start your Power BI project
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.