Power BI Weekly Issue 110: 18th May 2021
Lots of announcements this week:
- Announcing template apps one-click update
- Small Multiples (Preview) – Roadmap Updates
- On-premises data gateway May 2021 update is now available
- More control over when Azure Active Directory B2B guest users appear in lists of suggested people
- Using Out-Of-Line Bindings in Power BI
- Add and Edit Power BI data sources on Power Platform Admin Center
Not only that, but we've been given the Power BI May 2021 Feature Summary. Main features this month are the new visual tooltip with added drill actions, additions to DQ over Power BI Datasets functionality (lineage view, Q&A support), and a few features reaching GA.
Elsewhere this week, Carmel Eve has described How to use Azure Synapse SQL Serverless to connect Data Lake and Power BI, and Seth Bauer has written a comprehensive blog about How to Represent Your Power BI Skills, giving some sound advice for those thinking about or applying for a role requiring Power BI skills, but really the advice can be applied more generally for any technical skillset.
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
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.