Power BI Weekly Newsletter Issue #155

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) covers The Power Query XML Functions, Missing Or Null Values And Inconsistent Schema Inference
• On the RADACAD blog, Reza Rad (@Rad_Reza) discusses PL-300: Power BI Exam Prep: Connecting to data sources
• Chandeep Chhabra (@chandeep2786) describes how to Extract Any Step in Power Query
• James Andrew describes Six Simple Tips to Improve Your Power Query Efficiency within Power BI & Excel
• Bas Dohmen (@HowToPowerBI) describes How to use the Google Geocoding API in Power BI Quickly find Longitude and Latitude Coordinates
• On the Learning Science YouTube channel, Learning Science covers Language Detection in Power BI - Using AI Insights
• Reid Havens (@HavensBI) describes How To Quickly Add Notes In Power Query
• The Azure updates team writes about General availability: Azure Cosmos DB portal—Azure Synapse Link seamless Power BI
• On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) discusses Creating Tables in Power BI
• Ruth Pozuelo Martinez (@CurbalEN) shares 2 Free Cheat Sheets for Power BI
• On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about Custom Columns In Power BI Vs. Conditional Columns

Data Modeling

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

• On the SQLBI blog, Marco Russo (@marcorus) writes About waiting time for Power BI Desktop to open
• Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Introducing CALCULATE in DAX, talks about BETA.DIST, BETA.INV – DAX Guide and covers COMBIN, COMBINA – DAX Guide
• Antriksh Sharma (@AntrikshShar) describes the Complex behaviour of slicers in Power BI and on the Enterprise DNA blog, explains how to Connect DAX Studio To Power BI And SSAS
• Mimoune Djouallah (@mim_djo) talks about Tableau vs Power BI behavior in DirectQuery Mode , Result Cache
• On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) explains how to Create a Folder Measure and Folder Fields in Power BI desktop
• Daniil Maslyuk (@DMaslyuk) shares Power BI Antipatterns #8: Unformatted DAX
• On the Power BI Community blog, Polly Pu describes How to calculate about Matrix subtotal

Report Authoring and Interactivity

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

• On the Power BI blog, Ikechukwu Edeagu writes that Analyze in Excel Workbooks are now saved to OneDrive for Business
• Meagan Longoria (@mmarie) shares some Viridis color palettes in Power BI theme files
• Avi Singh (@powerbipro) describes How to Create Aging Reports by Bins/Buckets (Showing Open/Overdue Items)
• Soheil Bakhshi (@biinsightnz) writes about Thin Reports, What Are They, Why Should I Care and How Can I Create Them?
• Bas Dohmen (@HowToPowerBI) shares a Financial Statement Template Approach in Power BI and talks about Run to the MVP
• On LaDataWeb, Ignacio Barrau (@ignacho_07) describes how to Documentar informes con tooltips [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, Miquella de Boer (@MSPowerBI) announces High availability, load balancing and troubleshooting the Vnet gateway
• Patrick Leblanc (@GuyInACube) talks about Row-Level Security and Object-Level Security together in Power BI
• Marc Lelijveld (@MarcLelijveld) blogs about Sharing individual Power BI dataflows, but how?
• Gilbert Quevauvilliers (@GilbertQue) writes about Which Power BI Reports do I have access to? – Part 3 – Creating the "Power BI Users Reports List" report
• Rick de Groot (@Rickmaurinus) walks through Comparing Licenses in Power BI
• James Serra (@JamesSerra) discusses Power BI Performance Features
• On the Microsoft BI Tools blog, Joost van Rossum (@ssisjoost) explains how to Refresh Power BI Datasets with ADF or Synapse MSI
• On the Enterprise DNA blog, Antriksh Sharma (@AntrikshShar) describes How To Install SQL Server For Power BI
• On the Power BI Tips and Tricks blog, Steve Campbell (@PowerBISteve) discusses a Power BI Support Channel: Microsoft Teams Tips
• On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) talks about Power BI goals, How to set settings and how to set Values

General

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

• Dhruvin Shah (@DhruvinShah16) hosts a user group event: Developing Power BI Reports with PBI Tools with Mathias Thierbach
• Microsoft Power BI (@MSPowerBI) hosts The Power BI Community Show Ep 3 - Known Issues, Reports & Visuals, and Power BI Certifications
• Reid Havens (@HavensBI) presents Why Power BI Community Rocks with Nikola Ilic
• On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) presents Live Power BI Q&A with RADACAD - 2022-04-29

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.