Power BI Weekly Issue 140: 18th January 2022
First blog of the year from the Power BI team, with Jeroen ter Heerdt encouraging SSRS users using the Report Viewer control feature to migrate over to use Power BI Paginated Reports and Power BI Embedded, citing all the benefits of migration and the Modern Lifecycle Support Policy under which the Report Viewer Control feature is covered.
Aside from that update this week, we have plenty of great content to highlight. Daniil Maslyuk has written (and spoken) about Power BI Antipatterns #1: SWITCH(TRUE… in DAX. Aaron Watsky has described how to Give users the ability to change a slicer on a published report (mimicking the the dropdown report devs get in Power BI Desktop). And to continue from last week's editorial highlights, James Broome has described how to Test Power BI Reports with the ExecuteQueries REST API (IMO a primary use-case of this endpoint), and Paul Waller has described How to Build a Branded Power BI Report Theme, covering aspects like typography, cover pages, layout, and much more!
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Ben Gribaudo (@bgribaudo) writes about Custom Folding Joins: Tunneling State Between Table.Views and highlights Privacy Level Descriptions Revised
- Allison Kennedy covers Refresh Date in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Filter your Power Query columns by ANY CONDITION
- Sandeep Pawar (@PawarBI) describes Generating Random Numbers With Triangular Distribution in Power Query
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about Optimizing SUMMARIZE by using ADDCOLUMNS – Unplugged #40 and MEDIAN, MEDIANX – DAX Guide
- On the Tessellation Tech blog, Gavin Pedersen describes Power BI's SUM vs SUMX: What's the Difference, REALLY?
- Also on the Tessellation Tech blog, Spencer Baucke (@JSBaucke) writes about Creating a Measures Table in Power BI
- Daniil Maslyuk (@DMaslyuk) writes about Power BI Antipatterns #1: SWITCH(TRUE… in DAX (The Pilot)
- Reid Havens (@HavensBI) talks about Avoiding Bad DAX Practices with Daniil Maslyuk
- Rick de Groot (@Rickmaurinus) talks about Drillthrough for Measures using USERELATIONSHIP in Power BI
- Antriksh Sharma (@AntrikshShar) describes How To Sort Columns In Power BI and SSAS Using Tabular Editor 3 and C#
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about Hybrid tables in Power BI—The ultimate guide!
- Also on the Towards Data Science blog, Peter Hui writes about Power BI — All the important filters you need to know
- On LaDataWeb, Ignacio Barrau (@ignacho_07) writes ¿Por qué y cómo usar variables? [Spanish]
- On the Power BI Community blog, Zeon Zheng writes about Why there is no date hierarchy
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Paul Waller (@Crashbangwaller) describes How to Build a Branded Power BI Report Theme
- Bernat Agulló (@AgulloBernat) describes Charting time as hours and minutes
- Brian Julius describes How To Incorporate Dynamic Custom Icons Into Power BI
- On the Power BI community blog, Aaron Watsky (@A_WATT) explains how to Give users the ability to change a slicer on a published report
- Ruth Pozuelo Martinez (@CurbalEN) explains how to Make your tables look amazingly beautiful with these two tricks in Power BI
- Hafeez Jimoh (@jimohhafeezco) talks about Drilling down a Visual in Power BI and Conditional Formatting of Line Charts
- Hima Bindu Marri (@sivahimabindu) talks about Bookmarks in Power BI
- On the Learning Science YouTube channel, Learning Science talks about the Text Filter Custom Visual in Power BI
- On the Tessellation Tech blog, Hayley Hadges covers Power BI Beginner Basics: How to Create Toggle Switches and When to Use Them
- Patrick Leblanc (@GuyInACube) explains how to Add a little info to your Sparkline in Power BI
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, Jeroen ter Heerdt (@jeroenterheerdt) explains How to Integrate Power BI Reporting into .NET apps
- Philipp Lenz (@lenz_philipp) describes How To get Users who are assigned to Power BI Row Level Security Roles (Report Server and Power BI online)
- Chris Webb (@cwebb_bi) writes about Getting The IDs Of All Visuals In A Power BI Report Page Using The Power BI Embedded Analytics Playground
- On the endjin blog, James Broome (@jamesbroome_) writes about Testing Power BI Reports with the ExecuteQueries REST API
- On the Power BI community blog, Winniz Zhang explains How to view the frequency of user usage for all workspaces in Power BI
- On the Prologika blog, Teo Lachev (@tlachev) writes about DirectQuery Performance Progression
- Gilbert Quevauvilliers (@GilbertQue) walks through Using the Power BI Async REST APO to refresh a partition with Power Automate (Using an HTTPS URL)
- Sandro Pereira (@sandro_asp) describes How to Schedule Power BI Reports on Microsoft Teams
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Arnaud Gastelblum (@LazySna1l) blogs about Power BI Interview questions: a different way to know your applicants
- Lars Schreiber (@SchreiberLars) presents Chat with Rob Collie
- Sam McKay (@_EnterpriseDNA) talks about Power BI For Excel Users - Kick Start Your Analytics Journey
- Matthew Roche (@SQLAllFather) describes Simplifying the solution domain
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.