Power BI Weekly Newsletter Issue #136

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

• Chris Webb (@cwebb_bi) discusses Troubleshooting Power BI Timeouts, Part 2: Timeouts Specified In Power Query Functions
• Adam Saxton (@GuyInACube) asks Are you using the right Dataflows connector in Power BI?
• Lars Schreiber (@SchreiberLars) discusses Loading multivalued fields from Microsoft Access – not possible with Power Query
• On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) shows Getting Multiple Lookup Values in One Cell | Power Query
• Rick de Groot (@Rickmaurinus) writes about 4 Ways to Create Date Column for a Calendar in Power Query and explains How to Use List Generate to Make API calls 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 Different options to model many-to-many relationships in Power BI and Tabular, describes FACT – DAX Guide and describes RELATED, RELATEDTABLE – DAX Guide
• On the Towards Data Science blog, Nikola Ilic (@DataMozart) describes how to Boost Power BI performance by improving cardinality levels
• On the Power BI Tips and Tricks blog, Greg Baldini (@GregBaldini) writes about All Columns have Data Types in DAX, Or do they?
• Paul Turley (@paul_turley) wonders Are We There Yet? …Composite Models Using DirectQuery Over Power BI Datasets
• On the SQL Server Central blog, Adam Aspin provides an Introduction to DAX for paginated reports
• Leila Gharani (@LeilaGharani) shares DAX CALCULATE Function Made Easy to Understand (just one word)
• On the Learning Science YouTube channel, Learning Science talks about the COUNTROW, COUNT, COUNTBLANK, DISTINCTCOUNT, DISTINCTCOUNTNOBLANK & COUNTA Functions in Power BI
• Bernat Agulló (@AgulloBernat) blogs about Calculating the percentage of targets reached
• Brian Julius talks about What Are "Junk Dimensions" And Why They're Anything But Junk - Power BI Data Modeling Pro Technique
• Antriksh Sharma (@AntrikshShar) describes Using Multiple Columns with IN Condition in DAX

Report Authoring and Interactivity

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

• On the Power BI blog, Amanda Rivera (@MissAmandaN) explains how to Visualize your data quickly from Power Apps and Dynamics 365 apps (preview)
• Patrick Leblanc (@GuyInACube) describes how to Use Bookmark Navigator in Power BI to easily move through Bookmarks
• Matthew Peterson (@mattpetersonbi) talks about the Power BI: New Bookmark Functionality
• Bas Dohmen (@HowToPowerBI) describes the Custom Period Slicer in Power BI
• Reid Havens (@HavensBI) talks about Dynamic Font Color Logic with Conditional Formatting in Power BI
• Chandeep Chhabra (@chandeep2786) describes how to Highlight Missed Targets in a Line Chart
• Philipp Lenz (@lenz_philipp) explains how to Add comments to Power BI Visuals and the data by using Analysis Services Cubes
• On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) writes about Power BI Goals : Maintenant pour les détenteurs de licence Pro [French]

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, Ogbemi Ekwejunor-Etchie highlights that The CustomData feature is now generally available in Power BI
• David Eldersveld (@dataveld) writes about Microsoft 365 E5 and the Case of the Missing Power BI Pro
• On the CSG Pro blog, Simi Talkar explains How to Call Power BI REST APIs with Custom Connector and Postman
• Gilbert Quevauvilliers (@GilbertQue) discusses Power BI Premium/Premium Per User – Automating Processing of historical partitions
• On the SQL Shack blog, Aveek Das (@avikoleum) provides An overview of Power BI Incremental Refresh
• On the Tessellation Tech blog, Ryan Lurquin describes How and When to Use Power BI Row-Level Security
• On the RADACAD blog, Reza Rad (@Rad_Reza) describes how to Import Azure Active Directory Users into Power BI; A Step toward Dynamic Row-Level Security
• On the Power BI Community blog, Henry Kong describes how to Get historical refresh records for all datasets within organization via PowerShell
• Matthew Roche (@SQLAllFather) talks about Rebranding Data Governance

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) shares Announcing: The Power BI app for Microsoft Teams is now available in the US Government Community cloud
• The Power BI team (@MSPowerBI) explains how to Explore Power BI as a core capability in Microsoft Teams
• On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a Power BI Sample Dashboard Using Logistics Data
• On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) shares the talk: Data Culture with Matthew Roche
• Reid Havens (@HavensBI) discusses Driving a Data Culture with Power BI (with Tommy Puglia)
• Also on the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) discusses Measuring Data Culture Success
• On the RADACAD blog, Reza Rad (@Rad_Reza) blogs about the Skills Needed for a Power BI Developer
• On the Burningsuit blog, Stuart Box (@StuartBox) shares Strictly Come Dancing Power BI analysis
• Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (Dec 11, 2021)

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.