Power BI Weekly Newsletter Issue #116

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

• Adam Saxton (@GuyInACube) discusses Natives Queries or ODBC with Incremental Refresh in Power BI
• Imke Feldmann (@TheBIccountant) highlights that Power BI Cleaner Gen2 is here
• On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) describes Power BI File Clean up In a Few Steps and writes about Trim Vs Clean in Power BI and Power Query
• On the Power BI community blog, Fowmy Abdulmuttalib (@ExcelFort) describes Exponential Moving Average in Power Query (EMA)
• Jon Acampora (@excelcampus) explains How to Reorder Multiple Columns in Power Query with Drag & Drop
• Melissa de Korte (@_EnterpriseDNA) describes How To Extract Record Field Values From Lists
• Also on the Power BI community blog, Shanthakumar writes about a Date Transformation Issue in Power BI Service
• On the Access Analytic blog, Jeff Robson describes how to Unpivot using Column Numbers rather than Names
• Allison Kennedy blogs about Text Analytics in Power BI
• Chandeep Chhabra (@chandeep2786) writes about Dynamic Unpivoting in Power Query
• Ruth Pozuelo Martinez (@CurbalEN) explains how to Replace text with another column value in Power Query

Data Modeling

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

• Darren Gosbell (@darrengosbell) highlights the DAX Studio 2.16 Release
• On the SQLBI blog, Marco Russo (@marcorus) talks about the New preview features in DAX Studio 2.16 – Unplugged #25
• Reid Havens (@HavensBI) talks All about DAX.do (with Marco Russo)
• Antriksh Sharma talks through the DAX Studio 2.16 Bugs Fixes and Improvements and on the Power BI community blog, writes about a Circular Dependency between Calculated Columns in a Table in DAX
• Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) explains How to return 0 instead of BLANK in DAX, talks about ADDCOLUMNS – DAX Guide and describes DISTINCT, VALUES – DAX Guide
• On the Enterprise DNA blog, Nick Mone describes Filter In Power BI: DAX Queries Context Transition, DAX Calculation – Filter Context Transitions and Power BI Filters: Invoking Context Transitions
• On the Towards Data Science blog, Nikola Ilic (@DataMozart) lists the Top features in Tabular Editor 3 to boost your Power BI development
• Matthew Peterson (@mattpetersonbi) writes about Power BI: Time Intelligence Rolling Measures
• Chandeep Chhabra (@chandeep2786) covers Bottom N Analysis in Power BI
• On the Purple Frog Systems blog, Nick Edwards explains How to export more than 30,000 rows of data from Power BI Desktop.
• Dhruvin Shah (@DhruvinShah16) talks about the ALLSELECTED DAX Expression in Power BI
• Sam McKay (@_EnterpriseDNA) describes How To Create Custom Dimensions And Groups To Your Filtering Tables Fast In Power BI
• Brian Julius lists the Top 5 Tips & Tricks For Debugging Virtual Tables In Power BI
• Ruth Pozuelo Martinez (@CurbalEN) shares DAX Fridays #211: Add leading zeros to a column using DAX
• On the Power BI Community blog, Denis Selimovic (@DenSelimovic) answers Why is it sometimes not possible to select the exact number in the what-if parameter?

Report Authoring and Interactivity

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

• Philipp Lenz (@lenz_philipp) writes about the Paginated Report Visual and exporting data for printouts.
• Reid Havens (@HavensBI) walks through Creating a Custom KPI Card Using Charticulator (w/ Daniel Marsh-Patrick)
• On the Power BI Tips and Tricks blog, Steve Campbell (@PowerBISteve) discusses Power BI Bookmarks Tips, Tricks, and Best Practices
• On the Burningsuit blog, Alan Harman-Box describes Getting formatted text into your Power BI reports
• Also on the Burningsuit blog, Alison Box writes Charticulator in Power BI #5 and part #6
• On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) describes how to Design a custom chart inside Power BI desktop with Charticulator Custom Visual and explains How to embed Bot framework inside Power BI service dashboard
• Also on the RADACAD YouTube channel, Reza Rad (@Rad_Reza) covers Scope of Filter in Power BI Report and discusses Power BI Theme Customize Colors Fonts and Visual Appearance for Multiple Objects
• On the Enterprise DNA blog, Mudassir Ali shares a few blogs: Power BI Scatter Chart: Conditional Formatting, Power BI Donut Chart: Custom Visualization Tutorial and Power BI Heat Map: A Custom Visualization Tutorial

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, Bhavik Merchant (@BhavikMerchant) announces long-term usage and performance insights (Public Preview)
• Chris Webb (@cwebb_bi) describes Increasing Refresh Parallelism -And Performance – In Power BI Premium
• Gilbert Quevauvilliers (@GilbertQue) writes about Incremental Refreshing – Part 4 – Migrating AAS to PPU
• Philipp Lenz (@lenz_philipp) describes how to Process SQL Analysis Services Cubes via the Azure Data Factory

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, Jeroen ter Heerdt (@jeroenterheerdt) writes the Power BI June 2021 Feature Summary
• Also on the Power BI blog, Patrick Baumgartner (@patbaum) highlights that The Power BI report action bar is now available in the Power BI SharePoint Online webpart
• On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 196 - June News Round-up

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.