Azure Weekly - Power BI Weekly #265 - 2nd July 2024
Power BI Weekly Newsletter Issue #265
powered by endjin
Welcome to the 265th edition of Power BI Weekly! A very short edition this week. The only announcement is that of the Power BI Admin portal Usage metrics dashboard retirement, which (as you may have already noticed) is being superseded by the Admin monitoring workspace (preview) which includes additional granular insights. On the community articles-front this week: Roland Szirmai has walked through a scenario around Fixing Power Query CSV Import Issues using both the GUI and code, Justin Martin has described Creating User-Driven Default Slicer Selections to cater for scenairos where users are allowed to see all data, but their default view should be customized to default to their area, and Bas Dohmen has shown us 3 Power BI Visuals You Haven't Seen Before, including a dynamic column/line switching chart, a fill-card visual, and a customized funnel-style chart incorporating custom labels and the new ribbon functionality announced earlier this year.
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 sibling 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
- Roland Szirmai (@BILAnalytics) describes Fixing Power Query CSV Import Issues - No More Missing Columns in Power BI
- Dominique Vanasse (@lecfomasque) covers Power Query : Découvrez l’éditeur de requêtes pour Excel et Power BI [French]
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Reid Havens (@HavensBI) talks about Power BI Storage Modes in Microsoft Fabric (with Phil Seamark)
- Andrzej Leszkiewicz (@avatorl) blogs about Power BI Report Refresh Performance Analyzer
- Chris Webb (@cwebb_bi) writes about Calculate(), Filter() And DAX Memory Usage
- On the Power BI community blog, Arul explains How to Find Missing Customers in Power BI Using DAX Functions
- Justin Martin (@dax_noob_justin) describes Creating User-Driven Default Slicer Selections
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Bas Dohmen (@HowToPowerBI) talks about 3 Power BI Visuals You Haven't Seen Before
- Reid Havens (@HavensBI) talks about Easy-to-Read Multi-Variance Native Visual in Power BI
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Fabric blog, Bogdan Blaga (@MSPowerBI) announces Power BI Admin portal Usage metrics dashboard retirement
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Jason Cockington (@JasonCockington) covers Gartner Magic Quadrant for Business Intelligence – 2024 Update
- Romain Casteres (@PulsWeb) demonstrates Analyzing Solar Panel production and home energy consumption in real time with Microsoft Fabric
Useful Links
- Power BI Maturity Scorecard - 97% of the Fortune 500 are using Power BI. Only 20% of analytics deliver business value. How do you score?
- 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
- PowerQuery How - Alternative M Language Reference created by Rick de Groot, including improved function explanations, code formatting, practical examples and further reading
- 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
Tweet | Forward | Preferences | Unsubscribe
Older messages
Power BI Weekly #264 - 25th June 2024
Tuesday, June 25, 2024
Power BI Weekly Newsletter Issue #264 powered by endjin Welcome to the 264th edition of Power BI Weekly! No technical announcements this week, but Microsoft has yet again (unsurprisingly) been named a
Power BI Weekly #261 - 4th June 2024
Tuesday, June 4, 2024
Power BI Weekly Newsletter Issue #261 powered by endjin Welcome to the 261st edition of Power BI Weekly! I'll quickly mention the updates this week: we've been told that the general
Power BI Weekly #259 - 22nd May 2024
Wednesday, May 22, 2024
Power BI Weekly Newsletter Issue #259 powered by endjin Welcome to the 259th edition of Power BI Weekly! A handful of announcements and updates have been presented to us in preparation for Microsoft
Power BI Weekly #256 - 1st May 2024
Wednesday, May 1, 2024
Power BI Weekly Newsletter Issue #256 powered by endjin Welcome to the 256th edition of Power BI Weekly! No announcements this week, so we'll jump straight into the highlighted articles. Firstly,
☁️ Azure Weekly #464 - 28th April 2024
Sunday, April 28, 2024
Azure Weekly Newsletter Issue #464 powered by endjin Welcome to issue 464 of the Azure Weekly Newsletter. In AI we have a good mix of high-level and deep-dive technical articles. Next-Gen Customer
You Might Also Like
Aspire Deployment: Course Updates (coming soon)
Wednesday, October 23, 2024
Hey, it's Milan. Just wanted to share something I'm working on as we're getting closer to the .NET 9 release. I'm working on a brand new chapter for my courses about integrating .NET
📟 Turning Old Tech Into Keychains — How to Use Android's Theft Protection Feature
Tuesday, October 22, 2024
Also: Modern Video Games Are Too Easy, and More! How-To Geek Logo October 22, 2024 Did You Know When Galoob released the "Game Genie" product in the 1990s to allow players on the Nintendo
Unlock Python's Pattern Matching, Combinatoric Iterators, SSH Scripting, and More
Tuesday, October 22, 2024
Structural Pattern Matching in Python #652 – OCTOBER 22, 2024 VIEW IN BROWSER The PyCoder's Weekly Logo Structural Pattern Matching in Python In this tutorial, you'll learn how to harness the
Daily Coding Problem: Problem #1586 [Hard]
Tuesday, October 22, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Airbnb. An 8-puzzle is a game played on a 3 x 3 board of tiles, with the ninth tile
Mapped | The Home Price-to-Income Ratio of Large U.S. Cities 🏘️
Tuesday, October 22, 2024
The top five large US cities have a home price-to-income ratio more than double the national average of 4.7. View Online | Subscribe | Download Our App Presented by Hinrich Foundation NEW REPORT:
Ushering In
Tuesday, October 22, 2024
Netflix's Theatrical Strategy • Blade Runner vs. Elon Musk • Disney vs. App Store • Anthropic's AI PC Control • AirPods Hearing Boost Ushering In Netflix's Theatrical Strategy • Blade
Speeding up with SIMD and Go assembly
Tuesday, October 22, 2024
Plus some Go code generation magic, test parallelism, and working with Excel spreadsheets. | #528 — October 22, 2024 Unsub | Web Version Together with Ardan Labs Go Weekly A Taste of Go Code Generator
LW 155 - Optimizing Shopify Themes for Long Product Descriptions
Tuesday, October 22, 2024
Optimizing Shopify Themes for Long Product Descriptions Shopify Development news and articles
Secure Your Election 2024 eBook at the Best Value Today ⏰
Tuesday, October 22, 2024
Stay informed with our visual guide to the US Presidential Election—exclusively for VC+ members, along with additional updates. View email in browser Now Available: The Visual Guide to the US Election
Startups of The Year: How To Vote
Tuesday, October 22, 2024
Top Tech Content sent at Noon! How the world collects web data Read this email in your browser How are you, @newsletterest1? 🪐 What's happening in tech today, October 22, 2024? The HackerNoon