Power BI Weekly Newsletter Taster Edition

powered by endjin

Power BI Weekly Newsletter Issue #110

powered by endjin

Data Prep

Covering: Power Query (M), Dataflows, Data connectors, AI Insights

• On the endjin blog, Carmel Eve (@carmel_eve) explains How to use Azure Synapse SQL Serverless to connect Data Lake and Power BI
• Yousry Mohamed writes about Azure Synapse Analytics & Power BI
• On the Power BI community blog, Fowmy Abdulmuttalib (@ExcelFort) describes how to Split Amount Across Months Using Power Query
• Gil Raviv (@gilra) shares a New Recording: Low-Code Data Quality Automation
• Ruth Pozuelo Martinez (@CurbalEN) explains how to Get Power BI data in Excel without Pivot Tables | Excel Data Types
• Asanka Padmakumara (@asanka_e) writes Struggling to work with large models in your PC? This could help you
• On the MSSQLTips site, Kenneth A. Omorodion explains How to Create Date Dimension Tables in Power BI from Text Columns
• Philipp Lenz (@lenz_philipp) covers Stream Analytics and Power BI
• On the Power BI Community blog, Dedmon Dai writes about the Refresh error: The xxxx column does not exist in the rowset

Data Modeling

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

• Phil Seamark (@PhilSeamark) writes about DAX : Count number of last known state
• On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a few tutorials: KEEPFILTERS – DAX Guide, LOOKUPVALUE – DAX Guide, ALLCROSSFILTERED – DAX Guide and describes how to Show previous 6 months of data from single slicer selection
• Marco Russo (@marcorus) talks about Displaying the distribution of distance between transactions – Unplugged #19
• Rick de Groot (@ExcelGorilla) writes about 5 ways to calculate last 12 months in DAX for Power BI
• Patrick Leblanc (@GuyInACube) describes how to Test your Power BI DAX measures in DAX Studio
• Adam Saxton (@GuyInACube) talks about some Tools to take Power BI to the NEXT LEVEL
• Matthew Peterson (@mattpetersonbi) shares DAX Function USERELATIONSHIP Explained
• On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) shares an Advanced Sales Analytical Dashboard in POWER BI - Advanced DAX | Time Intelligence & KPIs | Measures
• Ruth Pozuelo Martinez (@CurbalEN) shares DAX Fridays #208: Open orders in DAX | Events in progress & Time intelligence
• Reid Havens (@HavensBI) talks about the ALM Toolkit External Tool with Christian Wade
• Hima Bindu Marri (@sivahimabindu) explains how to Calculate LTD in Power BI
• On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) describes How to use AddColumns function in DAX and Power BI and blogs about Power BI & Excel - with Tristan Malherbe
• On Qiita, Yugo Shimizu (@yugoes1021) writes [Power BI Tips] デフォルトで「今月」を表示するには？[Japanese]
• Chandeep Chhabra (@chandeep2786) discusses Summing Visible Values of a Table in Power BI

Report Authoring and Interactivity

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

• On the Power BI blog, Rien Hu shares the Small Multiples (Preview) – Roadmap Updates
• Matthew Peterson (@mattpetersonbi) talks about the Small Multiples Preview Feature
• Belinda Allen (@MsBelindaAllen) describes Using Small Multiples in Microsoft Power BI
• Brian Julius writes about the New Modern Visual Tooltips For Power BI
• Chris Webb (@cwebb_bi) shares a Video: Advanced Analytics Features In Power BI
• On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) discusses Microsoft Power Automate inside Power BI
• Alex Badiu (@BadiuAlexandru) discusses The Ultimate Dynamic Menu In Power BI
• On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) describes 3 façons d’utiliser les cartes de formes (shape maps) dans Power BI [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, Lukasz Pawlowski (@lukasztweets) highlights More control over when Azure Active Directory B2B guest users appear in lists of suggested people
• Also on the Power BI blog, Kay Unkroth describes Using Out-Of-Line Bindings in Power BI
• Also on the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) explains how to Add and Edit Power BI data sources on Power Platform Admin Center
• On the Power BI blog, Teddy Bercovitz (@Teddybbb) announces template apps one-click update
• Also on the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) shares that the On-premises data gateway May 2021 update is now available
• On the DAX Pro Services blog, Jesus Gonzalez describes how to Query catalog of a Power BI workspace with Azure Functions
• Chris Webb (@cwebb_bi) shares a Video: Performance Tuning Power BI Dataset Refresh
• Phil Seamark (@PhilSeamark) describes how to Visualise your Power BI refresh – in real-time
• Gilbert Quevauvilliers (@GilbertQue) writes about Query Performance – Part 1 Migrating Azure Analysis Services to Power BI Premium Per User
• Reid Havens (@HavensBI) describes how to Dynamically Filter Page Navigation Per User With Row Level Security (RLS)
• Dhruvin Shah (@DhruvinShah16) talks about the New Sharing Experience for Power BI Reports
• Imke Feldmann (@TheBIccountant) describes how to Fix error “..prod.powerquery.microsoft.com refused to connect” in Power BI dataflows
• Bas Dohmen (@HowToPowerBI) talks about GOALS in Power BI
• On the Marquee Insights blog, Treb Gatte (@tgatte) writes Power BI Goals Introduction – Part 2
• On the Prologika blog, Teo Lachev (@tlachev) takes A First Look at Power BI Goals
• On the CSG Pro blog, Brian Grant (@BrianGrantBI) writes about What to Expect When You're Expecting a Power BI Implementation

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) blogs about the Gartner Modern Analytics and BI Platforms Bake-off 2021: Analysis of impact of COVID-19 with Power BI
• Also on the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) shares the Power BI May 2021 Feature Summary
• Will Thompson (@Will_MI77) talks about the Gartner Modern Analytics and BI Platforms Bake-off 2021: Analysis of impact of COVID-19
• On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) share Episode 191 - Interview with Miguel Llopis
• On the Enterprise DNA blog, Paul Lucassen writes about Huff Gravity Model Analysis in Power BI
• Adam Saxton (@GuyInACube) shares Power BI tips from the Pros – LIVE (May 15, 2021)
• On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) explains How to Represent Your Power BI Skills
• Ruth Pozuelo Martinez (@CurbalEN) talks about Power BI Desktop Update May 2021 and MBAS

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.