Power BI Weekly
Issue #212 - 20th June 2023
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.
🛠️ Data Prep
- 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
- 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
- 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
- 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
- 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]