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
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Chandeep Chhabra (@chandeep2786) describes How to Fool Power BI and Create a 'Measures' Table
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- 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
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- 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
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.