Power BI Weekly Newsletter Issue #139

powered by endjin

If you have any content you'd like to contribute to the newsletter, please tweet @PowerBIWeekly or ping an email to PowerBIWeekly@endjin.com.

Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news.

@edfreeman_ | @endjin
powerbiweekly.info | endjin.com

Data Prep

Covering: Power Query (M), Dataflows, Data connectors, AI Insights

• Ben Gribaudo (@bgribaudo) covers Custom Folding Arbitrary Functions: OnInvoke & Table.ViewFunction
• On the MSSQLTips site, Kenneth A. Omorodion describes how to Concatenate Strings in Power BI Using Power Query M Language
• Allison Kennedy explains how to Get Data from SharePoint Files into Power BI
• Patrick Leblanc (@GuyInACube) presents Exploring Streaming Dataflows in Power BI

Data Modeling

Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models

• On the Towards Data Science blog, Salvatore Cagliari shares An unexpected lesson with calculating currency conversions in DAX
• Marc Lelijveld (@MarcLelijveld) shares Power BI Model Documenter v2
• Matt Allington (@ExceleratorBI) discusses Using Macros in Tabular Editor 3
• On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about LN, LOG, LOG10, EXP – DAX Guide and and SINH, COSH, ASINH, ACOSH, TANH, ATANH, COTH, ACOTH – DAX Guide
• On the SQL Server Central blog, Adam Aspin describes How to filter DAX for paginated reports
• Reid Havens (@HavensBI) discusses the Power BI Cleaner - External Tool (with Imke Feldmann)
• On the endjin blog, Elisenda Gascon (@elisendagascon) writes about Evaluation Contexts in DAX - Filter and Row Contexts
• On the Learning Science YouTube channel, Learning Science talks about the SUM and SUMX Functions in Power BI
• The Power BI team (@MSPowerBI) shares: Learn about hybrid tables in Power BI premium
• Bas Dohmen (@HowToPowerBI) describes Calculation Groups in Power BI
• Yugo Shimizu (@yugoes1021) shares [Power BI Tips] スタースキーマへの道 ～ モデリングってたぶんこれが基本 ～ [Japanese]

Report Authoring and Interactivity

Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards

• On the endjin blog, Paul Waller (@Crashbangwaller) covers Generating custom themes in Power BI – A designer's perspective
• On the Power BI community blog, Greg Deckler (@GregDeckler) blogs about Power BI Theme Generators
• Laura Graham-Brown (@Laura_GB) writes about a Charticulator Simple Custom Chart
• Olivier Travers (@otravers) writes about Advanced Power BI Custom Visuals: Options & Tradeoffs
• Greg Philps describes Exploring The Deneb Custom Visual In Power BI
• Chandeep Chhabra (@chandeep2786) presents Custom made Heat Maps using DAX
• Bas Dohmen (@HowToPowerBI) presents I Changed My Mind About GIFS Animated Images in Power BI
• On the RADACAD blog, Reza Rad (@Rad_Reza) discusses Sparklines in Power BI
• On the Learning Science YouTube channel, Learning Science talks about Pie and Donut Chart Rotation in Power BI - A technique to enable missing data labels
• Rick de Groot (@Rickmaurinus) discusses The Secrets of Drillthrough 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 endjin blog, James Broome (@jamesbroome_) writes about Why you should care about the new Power BI ExecuteQueries API
• Chris Webb (@cwebb_bi) describes how to Monitor Power BI Queries And Refreshes With DirectQuery On Log Analytics, Part 2: Dataset Refreshes
• Bernat Agulló (@AgulloBernat) talks about Bringing Tabular Editor C# scripts to the next level
• Philipp Lenz (@lenz_philipp) writes Continuous Deployment of Azure Analysis Services Cubes – Part 2 SQL Authentication

General

Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs

• On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 217 - Power BI 2021 Year in Review
• Matthew Roche (@SQLAllFather) blogs about Understanding the problem domain
• Marcus Wegener (@PowerBIler) presents Hey Peter! Power BI in Präsentation anstelle von PowerPoint nutzen [German]
• On the Power BI Tips and Tricks blog, the Explicit Measures podcast team (@PowerBITips) talks about Continuously Improving User Experience

Useful Links

• Azure Weekly - Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news
• M language reference - Official Power Query M Reference
• DAX Studio - Useful open source tool for executing and analyzing DAX queries, founded by Darren Gosbell
• DAX Guide - Your go-to reference on the DAX language, created by the SQLBI team
• Power BI Visuals Reference - An exhaustive list (as of Sep. 2018) of all Power BI native & custom visuals, placed into separate categories, again created by the SQLBI team
• Report Theme Generator - A handy report theme generator created by the Power BI Tips and Tricks team
• Power BI Theme templates - Detailed Power BI Theme templates for all the native visuals, created by David Eldersveld
• Power BI from Rookie to Rock Star - Free, detailed eBook to get up and running with Power BI, written by Reza Rad
• Power BI Architecture diagram - An informative Power BI Architecture diagram, created by Dustin Ryan
• Power BI Whitepapers - A list of official Power BI whitepapers, covering Security, Premium deployment, Advanced Analytics and more
• Power BI Events - Interactive report displaying upcoming Power BI events worldwide, built by Matt Allington, Phil Seamark and Reid Havens
• Power BI Days - Free-to-attend virtual and in-person community events, all across the world. If you're wanting to organize an event, that's possible too - it's still free, and comes with support.