Azure Weekly - Power BI Weekly #212 - 20th June 2023
Power BI Weekly Newsletter Issue #212
powered by endjin
Welcome to the 212th edition of Power BI Weekly! The monthly update is back to being the first link in the editorial after it was trumped by all the Fabric announcements last month. Find the full update here: Power BI June 2023 Feature Summary. Some really cool features have landed with this update - my favourite being the release of Power BI Desktop Developer Mode (Preview), which is a giant step towards giving Enterprise customers the version control and CI/CD capabilities people have been asking for for years. But a close second in my mind is the New card visual | Public preview, which improves upon the original card visual dramatically, allowing multiple cards to be created within a container (meaning we can stop with the visual hacks we've been doing up until now). It also introduces much more flexible and granular visual formatting, including custom display units and the ability to customize how BLANK is displayed.
Aside from monthly updates this month, Chris Webb has actually written about a feature that landed last month which was overshadowed by all-things Fabric, and that's the ability to Set Query Limits in Power BI Desktop, which allows us to simulate the frustrating “Visual Has Exceeded The Available Resources” Error In Power BI Desktop, which I'm sure many of you have encountered during your Power BI travels. Finally, there's now Chart sharing from organizational apps, allowing users to create links to individual charts and to open the visual in a PowerPoint deck.
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
- The Azure Updates Team (@Azure) announce Public preview: Power BI integration with Azure Database for PostgreSQL – Flexible Server
- Sandeep Pawar (@PawarBI) blogs about Using The Lakehouse Connector In Power BI Desktop
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes Duplicate vs Reference in Power Query
- On the Learning Science YouTube channel, Learning Science talks about What is query folding in Power BI?
- On the RADACAD blog, Leila Etaati (@leila_etaati) explains how to Convert Matrix data in Excel to Tabular Data in Power BI
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Adam Saxton and Marco Russo (@GuyInACube) discuss Understanding the Timeline in DAX Studio
- Ignacio Barrau (@ignacho_07) covers [PowerBi] Measure Killer - external tool para limpiar el modelo [Spanish]
- Jason Cockington (@JasonCockington) writes about Data Modelling for DirectQuery
- On the phData blog, Hayley Hadges (@phdatainc) describes Data Modeling Fundamentals in Power BI
- Marcus Wegener (@PowerBIler) covers Hey Peter! Trendlinie in Power BI mit eigener Datumstabelle [German]
- Allison Kennedy (@ExcelAllison) talks about Meaningful Power BI titles using DAX
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes Total Orders Amount Prior Period via DAX in MS Power BI (Explicit Measure) and describes how to Highlight Max & Min Bar in Visual with Different Colour in Power BI using an Explicit Measure DAX
- On the Learning Science YouTube channel, Learning Science describes How to bring a column from one table to another table in Power BI? | RELATED function in DAX
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI blog, Maya Shenhav (@MSPowerBI) announces Chart sharing from organizational apps. Also supported in PowerPoint integration.
- On the Power BI blog, Miguel Myers (@myersmiguel) announces New card visual | Public preview
- Chris Webb (@cwebb_bi) blogs about The “Visual Has Exceeded The Available Resources” Error In Power BI Desktop
- Bas Dohmen (@HowToPowerBI) delves into Push the limits of Power BI native visuals and captivate your audience | Timeline chart step-by-step, describes Quick tips for designing a menu in Power BI and shares Tips on adding icons to page names in Power BI
- Erik Svensen (@donsvensen) blogs about Power BI – Create a sparkline in the new card visual and some other nice formatting options
- Reid Havens (@HavensBI) describes Building Multi-language Reports for Power BI (with Ted Pattinson)
- On the Power BI community blog, Ray Wu writes about Using Custom Fonts in Power BI Server/Desktop
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes Instant Zebra BI Visual for Data Storytelling in Power BI Dashboard
- Dan English (@denglishbi) blogs about Drillthrough support in Paginated Reports now available
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, Rui Romano (@RuiRomano) shares Deep dive into Power BI Desktop Developer Mode (Preview)
- Paul Turley (@paul_turley) describes Introducing the New Power BI Project, and Why it is Important
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 259 - Fabric Licensing for Power BI
- John White (@diverdown1964) writes Understanding licensing for Microsoft Fabric from a Power BI perspective
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, Ryan Majidimehr (@MSPowerBI) announces Power BI June 2023 Feature Summary
- Miguel Félix covers Atualização Power BI Junho 2023 [Portuguese]
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
- 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
Key phrases
Older messages
☁️ Azure Weekly #423 - 18th June 2023
Tuesday, June 20, 2023
Azure Weekly Newsletter Issue #423 powered by endjin Welcome to issue 423 of Azure Weekly! Lots of little GA and Public Preview announcements this week, and a few interesting blog posts. First up the
Power BI Weekly #210 - 6th June 2023
Monday, June 12, 2023
Power BI Weekly Newsletter Issue #210 powered by endjin Welcome to the 210th edition of Power BI Weekly! A bit of a lull this week after a hectic week last week - hopefully you've had a chance to
☁️ Azure Weekly #422 - 11th June 2023
Monday, June 12, 2023
Azure Weekly Newsletter Issue #422 powered by endjin Welcome to issue 422 of Azure Weekly. ACI is a great technology, but often seen as expensive, so the public preview of Azure Container Instances (
☁️ Azure Weekly #420 - BUILD Special - 28th May 2023
Sunday, May 28, 2023
Azure Weekly Newsletter Issue #420 powered by endjin Welcome to issue 420 of Azure Weekly. It's an absolute beast this week. Microsoft BUILD was as epic as expected. As usual a great condensed
Power BI Weekly #206 - 9th May 2023
Tuesday, May 9, 2023
Power BI Weekly Newsletter Issue #206 powered by endjin Welcome to the 206th edition of Power BI Weekly! This week we've had a pretty clear call-to-action to Register for Microsoft Build to hear
You Might Also Like
Behind the Product – Miro
Monday, April 29, 2024
Brought to you in partnership with CustomerIQ The AI platform to help teams aggregate, search, and synthesize customer feedback. CustomerIQ aligns teams with insights from channels like CRM notes,
Rapidly responsive... space stations!?
Monday, April 29, 2024
There are scant details as to the mission profile, but I can't help but feel intrigued by this news from Gravitics View this email online in your browser By Aria Alamalhodaei Monday, April 29, 2024
Daily Coding Problem: Problem #1426 [Hard]
Monday, April 29, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Salesforce. Given an array of integers, find the maximum XOR of any two elements.
Code Story - Mar 24
Monday, April 29, 2024
Welcome to the March addition of the podcast newsletter. Please enjoy, and check out any of the episodes you might have missed below. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Feature | The Best Visualizations from April on Our New App 📲
Monday, April 29, 2024
See the most popular, most discussed, and most liked visualizations on our new data storytelling app Voronoi from April. View Online | Subscribe At the end of 2023, we publicly launched Voronoi, our
😸 Tangible change
Monday, April 29, 2024
🤖 Elon is closing in on $6 billion in funding for his AI startup. 🛜 The FCC has officially voted... Product Hunt Read in browser This newsletter is brought to you by YOU MIGHT HAVE MISSED 🤖 Elon is
⚙️ AI has emotions now
Monday, April 29, 2024
Plus: Meta AI? More like Mid-ta AI!
Yikes! Copilot failed all our coding tests
Monday, April 29, 2024
iPad Pro with M4; Best security keys; AI conducts job interviews now -- ZDNET ZDNET Tech Today - US April 29, 2024 placeholder Yikes! Microsoft Copilot failed every single one of my coding tests I ran
Re: The smart home product I use every day!
Monday, April 29, 2024
Hey , Earlier this month, I emailed you about one of my favorite smart home products, a robot vacuum and mop. I wanted to let you know that Samsung currently has a Spring Black Friday Sale and is
The EU draws its regulatory cords tighter around Apple
Monday, April 29, 2024
The EU has said Apple's iPadOS will now fall under the DMA View this email online in your browser By Alex Wilhelm Monday, April 29, 2024 Welcome to TechCrunch AM! We're off to a quick start