Power BI Weekly Newsletter Issue #135

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

• On the Power BI blog, Krrish Dholakia provides a Power BI Streaming Dataflows November Update
• Rui Romano (@RuiRomano) blogs about Power BI Dataflows & Object Level Security (table level)
• On the dev.to blog, Marvin D. Tensuan discusses Power BI's Power Query (M) for Python Programmers
• Gašper Kamenšek (@ExcelUnplugged) writes about AI in Excel – Part 2 – Column From Examples
• On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) covers Power Query Keyboard Shortcuts to Save Time
• Parker Stevens (@PowerBIElite) covers Making sure your Power BI web data source refreshes online (RelativePath, Query, BrowserContents)
• On the Enterprise DNA blog, Gaelim Holland describes Power BI With Python Scripting To Create Date Tables

Data Modeling

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

• Alberto Ferrari (@FerrariAlberto) presents Answering questions: running total and last dates within selection – Unplugged #38, and shares a couple of tutorials MOD, QUOTIENT – DAX Guide and CONVERT, INT, CURRENCY – DAX Guide
• Jeroen ter Heerdt (@jeroenterheerdt) discusses The capitalization (uppercase / lowercase) of my text data changed in Power BI! Why?
• On the Purple Frog Systems blog, Joe Billingham walks through Making the DAX Engine Work for You
• Chandeep Chhabra (@chandeep2786) covers Optimizing IF using MAX and MIN Functions
• On the MSSQLTips site, Kenneth A. Omorodion describes how to Dynamically Compute Different Time Duration in Power BI Using DAX
• Ruth Pozuelo Martinez (@CurbalEN) introduces the 25 Days of DAX Fridays! Challenge | Are you in?
• On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about the CALCULATE Function – How It Can Affect Your Calculations On Power BI
• Reid Havens (@HavensBI) talks about Tabular Editor 3: Present & Future with Daniel Otykier

Report Authoring and Interactivity

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

• On the RADACAD blog, Reza Rad (@Rad_Reza) talks about Power BI From and To Date Filtering with One Slicer
• Greg Philps describes Using Deneb For Flexible Custom Visuals In Power BI
• Bas Dohmen (@HowToPowerBI) describes a KPI car hover effect in Power BI
• Patrick Leblanc (@GuyInACube) describes how to Use Page Navigator in Power BI
• On the Learning Science YouTube channel, Learning Science talks about the Bookmark Navigator in Power BI
• Dhruvin Shah (@DhruvinShah16) talks about the New Format Pane in Power BI Desktop
• Rajat Talwar discusses All you should know about Power BI Goals and AI
• Brian Julius provides a Sort Legend Tutorial And Review

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, Noam Raveh announces the Power BI APIs .NET SDK v4
• Also on the Power BI blog, Miquella de Boer announces that the On-premises data gateway November 2021 update is now available
• Chris Webb (@cwebb_bi) discusses Troubleshooting Power BI Timeouts, Part 1: The Two/Five Hour Import Refresh Limit
• Adam Saxton (@GuyInACube) describes how to Call any Power BI REST API with PowerShell
• On the Blue Granite blog, Elayne Jones describes Digging into Power BI Deployment Pipelines
• Philipp Lenz (@lenz_philipp) writes about Continuous Deployment of Azure Analysis Services
• Reid Havens (@HavensBI) covers Migration Tips and tricks when moving from AAS to PPU w/ Gilbert Quevauvilliers and Havens Consulting discusses The Data God Guide to Power BI Gen2 with Chris Wagner - Kratos BI
• On LaDataWeb, Ignacio Barrau (@ignacho_07) writes Librería de Python para Power Bi Rest API [Spanish]

General

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

• Nicky van Vroenhoven (@NickyvV) writes about My Favorite Power BI Desktop November Updates
• Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (Dec 4, 2021)
• On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) talks about Trolling the Power BI Ideas Site

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.