Power BI Weekly
Issue #201 - 4th April 2023
Just a single announcement this week - a small (yet mighty) feature has landed, which is the ability to Pin workspaces in the Power BI Service. Finally! Thanks to the Power BI team for listening to the community on this one. Elsewhere this week, Matthew Adams has elaborated on the importance of Asking the right questions to get your data insights projects back on track. In it, Matthew shares a new (free) high-level Power BI Maturity assessment we've devised at endjin to help you understand your organization's maturity based on three fundamental activities: understanding who is involved, how they derive value from your Power BI activities, and how they communicate with each other. Do take a read through that blog if you're interested!
I'll finish off the editorial with a couple of "programmatic" tips this week: Gilbert Quevauvilliers has highlighted the Resolve-PowerBIError
PowerShell cmdlet in the blog Troubleshooting Power BI PowerShell issues to view the error (which, despite being very familiar with the various Power BI SDKs, I'd somehow not come across before). This, unsurprisingly, provides a bit more information about errors that other PowerShell Power BI cmdlets may throw, which, by themselves, tend to be very vague. The other blog I'd like to highlight is written by Nandan Hegde, who has spoken about Overcoming Data Size / Row Limitations of Power BI REST API for Automated Data Extraction from Dataset. If you need to extract more than 15MB / 100,000 values, this is well worth a read.
🛠️ Data Prep
- Belinda Allen (@MsBelindaAllen) explains how to Add a prefix to a field in Microsoft Power BI via Power Query
- Denis Selimovic (@DenSelimovic) writes about One-step conditional value replacement in a column in Power Query
- Chandeep Chhabra (@chandeep2786) describes how to Remove Random Null Values from Columns
- Olivier Travers (@otravers) writes about Connecting to Power BI Datamart and PowerApps Dataverse's SQL Server from Desktop Tools and External Services
🧩 Data Modeling
- On the SQLBI blog, Marco Russo (@marcorus) blogs about Optimizing fusion optimization for DAX measures
- On the SQL Server Central blog, Jared Westover (@WestoverJared) describes DAX CASE Statement Functionality with IF, SWITCH and SWITCH True
- Sam McKay (@_EnterpriseDNA) explains How To Detect And Visualize Outliers Using DAX In Power BI [2023 Update]
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes how to Place all explicit measures in one table in Power BI
📊 Report Authoring and Interactivity
- Mara Pereira (@datapears) covers The Importance of User Experience in Reporting and Power BI - A Must-Read Guide
- Marc Lelijveld (@MarcLelijveld) blogs about The Truth About Hiding Pages in Power BI Reports: Why It's Not a Security Feature
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes On object interaction (Opt-in) and talks about Star Rating Visual in Microsoft Power BI
- Bas Dohmen (@HowToPowerBI) discusses Slicer design 2.0 in Power BI | Upgraded functionality and UX and explains how to Add power to your titles in Power BI | The one trick you need to know
- Brian Julius (@_EnterpriseDNA) explains How To Create Fully Dynamic Image Slicers In Power BI
- On the Select Distinct blog, Select Distinct (@SelectDistLtd) blogs about Sparklines in Power BI
- On the Learning Science YouTube channel, Learning Science talks about Sankey Chart in Power BI - Custom Visual
- Dhruvin Shah (@DhruvinShah16) talks about the Apply All and Remove All Button in Power BI
- On the MSSQLTips site, Harris Amjad (@mssqltips) explains How to use the Custom Power KPI Visual in Power BI
- Matt Allington (@ExceleratorBI) explains how to Build a Power BI Paginated Report Online
- Laura Graham-Brown (@Laura_GB) describes Power BI – Embed a Paginated Report
🚀 Deployment, Security and Operations
- On the Power BI blog, Yichao Wu (@MSPowerBI) announces Pin workspaces
- Reid Havens (@HavensBI) walks through Introducing TMDL for Power BI (with Mathias Thierbach) and presents Power BI Governance (Why Should I Care) (with Ásgeir Gunnarsson)
- Gilbert Quevauvilliers (@GilbertQue) describes Troubleshooting Power BI PowerShell issues to view the error
- Chris Webb (@cwebb_bi) covers Identifying CPU And Memory-Intensive Power Query Queries During Refresh In The Power BI Service
- Nandan Hegde (@nandan_hegde15) describes Overcoming Data Size / Row Limitations of Power BI REST API for Automated Data Extraction from Dataset
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about Content Certification in Power BI: One Step Towards a Better Governance
- Patrick Leblanc (@GuyInACube) describes how to Switch a Power BI Report’s dataset without needing Premium
- Antriksh Sharma (@AntrikshShar) explains how to Refresh Individual Power BI Tables or Partitions with PowerShell
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) talks about Last Refreshed in Power BI (Desktop + Service) and delves into Getting Started with Microsoft Power BI Service
🌐 General
- On the endjin blog, Matthew Adams (@ythos) writes Ask the right questions to get your data insights projects back on track
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 251 - Power BI News Updates
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 219