Power BI Weekly Newsletter Issue #142

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

• Gašper Kamenšek (@ExcelUnplugged) blogs about Data Types – Part 1 – Create Your Own Data Types in Power Query
• James Andrew covers Creating Absolute Values within Power Query Custom Columns
• Ruth Pozuelo Martinez (@CurbalEN) blogs about The best way to combine files in Power BI so you don't lose columns
• Gaelim Holland talks about Using Python Sentiment Analysis
• Hima Bindu Marri (@sivahimabindu) covers Parameterization of data sources in Power BI

Data Modeling

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

• On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about the Performance of sparklines in Power BI – Unplugged #41, and shares a few tutorials: GCD, LCM – DAX Guide, EXPON.DIST – DAX Guide and FLOOR, MROUND, CEILING, ISO CEILING – DAX Guide
• Brian Julius (@_EnterpriseDNA) describes How To Create Self-sorting Columns In Power BI
• Daniil Maslyuk (@DMaslyuk) covers Power BI Antipatterns 2: SELECTEDVALUE
• Arnaud Gastelblum (@LazySna1l) writes about 'DAX is case insensitive'

Report Authoring and Interactivity

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

• On the Zebra BI site, Matija Kocevar describes How to choose the correct chart type for your Power BI report
• Fowmy Abdulmuttalib (@ExcelFort) describes How to Make a Pareto Chart in Power BI Step-By-Step Tutorial - Part 1 and Pareto Chart with ties In Power BI - Step-By-Step Tutorial - Part 2
• Ruth Pozuelo Martinez (@CurbalEN) describes How to add annotations to a chart in Power BI to provide an explanation or more context
• On the Tessellation Tech blog, Gavin Pedersen explains How to Make the Most of Power BI Tooltips
• Adam Saxton (@GuyInACube) describes How Parameters work with the Power BI Paginated Visual and explains how to Create a date range parameter with Power BI Paginated Reports
• Also on the Tessellation Tech blog, Spencer Baucke (@JSBaucke) blogs about Optimizing Power BI Reports
• James Andrew describes how to Dynamically Highlight Column Values Within Power BI Using DAX & Conditional Formatting
• On the Perficient blog, Vaibhav Punwatkar explains how to Hide and Show Slicer Pane in Power BI Desktop
• On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) writes about 3 Ways with Slicers in Power BI
• Bas Dohmen (@HowToPowerBI) explains how to Embed Images in Power BI and describes a Power BI Write Back Option with Power Apps
• On the RADACAD YouTube channel, Rui Romano (@RuiRomano) talks about Power BI Development on Steroids
• Also on LaDataWeb, Pablo Deheza writes Formato Condicional para Grafico de Líneas [Spanish]

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) shares a Reminder: WebView2 will be required for the next Power BI Desktop release and explains how to Collect diagnostic information for Power BI
• On the RADACAD blog, Reza Rad (@Rad_Reza) describes how to create a Power BI Sandbox: An Environment to Learn Power BI Service for Free
• On the Blue Granite blog, Elayne Jones blogs about Migrating Azure Analysis Services Models to PBI Premium
• Chris Webb (@cwebb_bi) writes Monitor Power BI Queries And Refreshes With DirectQuery On Log Analytics, Part 4: Query Sessions
• Reid Havens (@HavensBI) discusses Deploying Reports with PBI-Tools with Mathias Thierbach
• On the Marquee Insights blog, Treb Gatte (@tgatte) highlights that Power BI Goals available now with a Pro License and explains how to Add multiple Power BI Goal owners
• Gilbert Quevauvilliers (@GilbertQue) explains How to use the Power BI Embedded Playground
• On the Tessellation Tech blog, Gavin Pedersen explains How to Create a Power BI App
• On the Learning Science YouTube channel, Learning Science describes How to access Power BI Report and Dashboard on Mobile Devices
• Mathias Halkjær Petersen (@HalkjaerM) talks about Complex access control with Row-Level Security
• The Power BI team (@MSPowerBI) explains how to Learn about new centralized data loss prevention policies

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) shares the Power BI Report Server January 2022 Feature Summary
• Also on the Power BI blog, Mrigankka Fotedar explains how to Optimize your Processes and Gain Deep Insights with Process Mining

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.