Power BI Weekly
Issue #227 - 3rd October 2023
A short edition this week, but there are a few updates. Not sure how I missed this one, but a couple of weeks ago we were told about the new Enhanced Admin Portal Experience with Keyword-Based Filtering, which does exactly what it says on the tin. We've also been made aware that the Power BI OneDrive and SharePoint on by default rollout has started, whereby the preview of Power BI files will be enabled by default if your org hasn't turned it off. Finally, we've been given the Power BI Report Server September 2023 Feature Summary, which comprises mainly a small set of "viewing" improvements.
We do also have a couple of community tools that have been introduced this week: Chris Webb has shared a tool created by his colleague Nat Van Gulck: VisOps For Power BI With PBI Inspector, which allows you to define rules against the visual elements of your report and check for breaches, using either a GUI or the command line. This will make a great addition to your enterprise reports release pipelines, if you ask me (in addition to your data model testing suite, of course!) The other tool that some of you might enjoy is the new Power BI Report Previewer Browser Extension created by Vahid Doustimajd, which provides a way to preview your Power BI reports in the workspace "list" view.
🛠️ Data Prep
- On the MSSQLTips site, Harris Amjad (@mssqltips) describes Exploring the Split Columns Option in Power Query Editor for Power BI
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) describes how to APPEND data in Power Query
- On the phData blog, Bhupathi Siva (@phdatainc) explains How and When to Use Dataflows in Power BI
🧩 Data Modeling
- Chandeep Chhabra (@chandeep2786) describes How to Fool Power BI and Create a 'Measures' Table
📊 Report Authoring and Interactivity
- Philipp Lenz (@lenz_philipp) explains how to Hide columns inside Power BI like in Excel
- Max Wikström (@maxwiks) writes about Dynamic shading in Power BI native line charts: Comparing values
- On the xViz blog, Prachi Mishra (@xvizsuite) writes about Multi-level Timeline in the xViz Gantt Chart for Power BI
- On the phData blog, Connor Burton (@phdatainc) describes What Are Power BI Paginated Reports?
- On the Learning Science YouTube channel, Learning Science explains How to add Paginated Report in Power BI Report? | Paginated Report Visuals in Power BI
- Avi Singh (@powerbipro) shares Power BI Dashboard: Oil Industry Production Tracking by Charl Marais
🚀 Deployment, Security and Operations
- On the Power BI blog, Radhakrishnan Srinivasan (@MSPowerBI) describes Enhancing Admin Portal Experience with Keyword-Based Filtering
- Also on the Power BI blog, Lauren Faber (@MSPowerBI) writes that the Power BI OneDrive and SharePoint on by default rollout has started
- Chris Webb (@cwebb_bi) blogs about VisOps For Power BI With PBI Inspector
- Gilbert Quevauvilliers (@GilbertQue) describes How to easily send an Excel extract using a paginated report in Power BI
- Vahid Doustimajd (@VahidDoustiM) covers Power BI Report Previewer: Useful Browser Extension for Power BI Users
🌐 General
- On the Power BI blog, Cookie McCray (@MSPowerBI) announces Power BI Report Server September 2023 Feature Summary
- Soheil Bakhshi (@biinsightnz) writes Unveiling Microsoft Fabric's Impact on Power BI Developers and Analysts
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 238