Generated by All in One SEO v4.9.10, this is an llms.txt file, used by LLMs to index the site.## Sitemaps - [XML Sitemap](https://datavibe.co.uk/sitemap.xml): Contains all public & indexable URLs for this website. ## Posts - [Blogs](https://datavibe.co.uk/blogs/) - [The Fabric Blueprint: Architecting Workspaces for Enterprise Success](https://datavibe.co.uk/the-fabric-blueprint-architecting-workspaces-for-enterprise-success/) - This quick guide establishes the organizational standard for managing Microsoft Fabric within our enterprise environment. By adopting these patterns, we ensure security, maintainability and streamlined CI/CD deployments across all data projects. 1. The Core Architecture: The Environment-Based Pattern The Concept: Separate environments based on the Software Development Life Cycle (SDLC). Assets should never be developed - [The Auditor's Toolkit: Reporting on Your Tenant](https://datavibe.co.uk/the-auditors-toolkit-reporting-on-your-tenant/) - Your boss walks by your desk on a Friday afternoon with the dreaded question: "Can you give me a full audit of who has access to what in our tenant? I need to know every workspace and exactly who is in it." You look at the clock. It’s 4:30 PM. Your weekend plans are already - [The Fabric Admin Trap: Scaling Your Cleanup](https://datavibe.co.uk/the-fabric-admin-trap-scaling-your-cleanup/) - 1. From Manual Clicking to CLI Mastery We’ve all been there. It’s Friday afternoon, and you're looking at your Microsoft Fabric tenant. It’s cluttered with dozens of abandoned test workspaces, half-finished projects, and "oops, I forgot to delete this" environments. You open the portal. You click. You wait for the page to refresh. You click - [Site to Insight: Fabric’s New SharePoint Picker](https://datavibe.co.uk/site-to-insight-fabrics-new-sharepoint-picker/) - One of the greatest things about attending FABCON in Atlanta recently wasn't just the incredible community or the deep-dive sessions - it was those "aha!" moments during the keynote announcements. Among the many massive reveals, there was one specific update that caught my attention as a massive "quality of life" win: the SharePoint Site Picker - [Stop Polling, Start Reacting: Building Bulletproof Event-Driven Pipelines in Microsoft Fabric](https://datavibe.co.uk/stop-polling-start-reacting-building-bulletproof-event-driven-pipelines-in-microsoft-fabric/) - I just stepped off the stage at SQLSaturday Atlanta and the energy around Microsoft Fabric is absolutely electric. Between the deep-dive sessions and the hallway conversations, one question kept coming up: “How do we make our data orchestration more efficient?” In the world of Synapse and Data Factory, we’ve been conditioned to "Poll." We set - [Global CO2 Emissions Analysis](https://datavibe.co.uk/global-co2-emissions-analysis/) - Hello Everyone, This is my first post to storytelling on my blog. I will posting more data stories soon. CO2 emissions globally are impacting the world in different ways. I have tried to create some analysis at Region and Country level to see how the impact has been overtime and whether the countries are taking - [DP-600 Fabric Analytics Engineer Associate Certification](https://datavibe.co.uk/dp-600-fabric-analytics-engineer-associate-certification/) - The new Fabric Analytics Engineer Associate Certification was announced in November 2023 and now it has finally come out of the Beta mode and is Live now. We have been seeing many posts in the community from people taking this certification and passing them. If you haven't tried it yet, Why not try this certification - [Exploring Fabric SQL Endpoint - Data & Model View](https://datavibe.co.uk/exploring-fabric-sql-endpoint-data-model-view/) - Another day and another opportunity to learn something new! If you have been following my blogs on the Microsoft Fabric, then this blog is the 4th in the series of blogs I plan to write in the coming months on Microsoft Fabric. If Fabric is still a new term to you, you can go back - [Getting On-Premises SQL Server Data to Fabric Lakehouse](https://datavibe.co.uk/getting-on-premises-sql-server-data-to-fabric-lakehouse/) - For the last few days, I have been working on the Contoso Sales data to create a Power BI report as part of the learning. Currently, I am using the default ready to go Power BI data model provided by Microsoft which can be found here. As Microsoft Fabric is the new tech buzz, so - [Microsoft Fabric - Getting Started](https://datavibe.co.uk/microsoft-fabric-getting-started/) - If you have already understood the basics behind Microsoft Fabric, then this is time to get started with it. If not, then no worries. You can check my introductory blog on Microsoft Fabric and familiarize yourself with it and come back to this blog as a next step. Let's get started. Enable Microsoft Fabric In - [Microsoft Fabric - SaaSified Analytics Solution](https://datavibe.co.uk/microsoft-fabric-saasified-analytics-solution/) - Microsoft Fabric is the new buzz in the technology industry these days and everyone wants to get their hands-on on this new tech-stack. Are you also among this group who wants to learn Microsoft Fabric? Do you want to start soon with this new tech and explore it's potential? Do you want to understand how - [Icons & Data Labels on Top of the Bars with Conditional Formatting](https://datavibe.co.uk/icons-data-labels-on-top-of-the-bars-with-conditional-formatting/) - "A day without a challenge, is a day without a learning!" Today, I got a requirement from a client, where they asked for getting data labels along with icons along with conditional formatting, on top of the bars represented in a clustered column chart. Now this is something I had not done before, so started - [Power BI - The New Card Visual Part 1](https://datavibe.co.uk/power-bi-the-new-card-visual-part-1/) - Current month Power BI update has got so many additions to it from having new card visual to Power BI Developer Mode; On-Object interaction updates to Admin Monitoring and so on. It just feels like a feast this month as we have got some capabilities that we as Power BI Developers have been waiting for - [Power BI Learning Resources](https://datavibe.co.uk/power-bi-learning-resources/) - In the last couple of days, many of my connections on LinkedIn have approached me for good Power BI resources that can be used by beginners for learning this amazing tool. There are multiple resources out there which are really amazing for getting started with Power BI. Therefore, I have come up with a summary - [Mental Health - How are you?](https://datavibe.co.uk/mental-health-how-are-you/) - I have been quiet for a while on the social media and have not been heavily posting/sharing things like I used to before. We as humans have a tendency to over work most of the times and then end up being burnout - a state of physical & emotional exhaustion. I am here exactly trying - [Global Oil Production and Consumption Analysis](https://datavibe.co.uk/global-oil-production-and-consumption-analysis/) - Hello Everyone,This month's data story shows some new trends and insights.This month I have taken data related to the Global Oil Reserves, Oil Production and Oil Consumption. Uisng this data, I have tried to generate some trends and insights.This analysis looks at mainly - global oil reserves, oil production & oil consumption trends from 1980 to - [Spotify Trends](https://datavibe.co.uk/spotify-trends/) - Hello Everyone, Some new data this time, some new trends and some new insights. This time I have taken data related to Spotify musical app and tried to generate some trends and insights out of this data. This analysis looks at mainly - trend around streams overtime on Spotify platform what are the most trending - [What is the best piece of Career Advice you ever received?](https://datavibe.co.uk/what-is-the-best-piece-of-career-advice-you-ever-received/) - My fellow community leader Gethyn Ellis is hosting TSQL2Sday this month. TSQL2sDay is a great opportunity for someone new to blogging to get involved. If you want to get involved but need help knowing where to start, just let us know, and we will help. I'm sure there will be plenty of other people happy - [Custom Date Formats in Power BI Using a Slicer](https://datavibe.co.uk/custom-date-formats-in-power-bi-using-a-slicer/) - Ever thought of displaying dynamic date formats using a slicer in a Power BI dashboard? Today in this blog I will be talking about how we can modify date formats dynamically in a Power BI dashboard. The blog includes usage of a disconnected table for these custom date formats, which can further be used as - [Current & Previous Year Sales Based On Selection](https://datavibe.co.uk/current-previous-year-sales-based-on-selection/) - Let us consider the following bar chart visual, which visualises the total sales over years. Now the requirement is, when I click on one of the bars in the above visual, I want to display the selected year sales and the previous year sales in 2 additional card visuals. Let us see how we can - [What-If Parameters Use-case](https://datavibe.co.uk/what-if-parameters-use-case/) - Let us take up a scenario where we have customers associated with a store. The store generates a monthly reporting on what their total sales are, and, on the report, total sales metric is summarised at a customer level. Just imagine a table displaying all these customers with the total sales they generated for the - [Handling Duplicate Ranking using RANKX DAX Function](https://datavibe.co.uk/handling-duplicate-ranking-using-rankx-dax-function/) - Power BI supports a functional language called DAX (Data Analysis Expressions), which basically represents an executable piece of code inside a function. DAX expressions can be sometimes difficult to use and understand. There are multiple DAX expressions out there, but today I will be concentrating on a problem statement on using RANKX function, and how - [Power BI - Model View in a Nutshell](https://datavibe.co.uk/power-bi-model-view-in-a-nutshell/) - Power BI has improved the Model view a lot in the last few monthly updates. In this article I will highlight the key benefits of some of the new features that make the Model view quite strong from modelling point of view and makes the life of a report developer easier in many ways. Here - [Schedule Automated Data Exports using R/Python Script in Power BI](https://datavibe.co.uk/schedule-automated-data-exports-using-r-python-script-in-power-bi/) - Today in this blog we will talk about scheduling the data exports from Power BI. I have recently come across a requirement where I need to send regular data exports of a dataset in one of my Power BI report. It is quite easy to just export this dataset from Power Bi Desktop itself by - [Toggle Between Charts in Power BI](https://datavibe.co.uk/toggle-between-charts-in-power-bi/) - Let us consider a scenario where we need to represent similar information at two different category levels. One potential and easiest way would be to create 2 charts or 2 visuals representing same metric at different levels. Like the one shown below: In the above charts, I am displaying total transaction value by Region and ## Pages - [Home](https://datavibe.co.uk/) - Keep Learning, Keep Exploring! - [About Data Vibe](https://datavibe.co.uk/about-data-vibe/) - Empowering Organizations through Unified Analytics and Strategic Data Leadership. At Datavibe Solutions Ltd, we bridge the gap between complex technical architecture and strategic data leadership. Based in London and serving a global clientele, we specialize in the Microsoft Data Stack, with a core focus on end-to-end Microsoft Fabric implementations and enterprise-scale Power BI ecosystem design. - [Speaking Engagements](https://datavibe.co.uk/speaking-engagements/) - January 2024 10th Jan 2024 - Power BI Women User Group November 2023 10th Nov 2023 - Finding Data Friends 13th Nov 2023 - PASS Data Community Summit 24th Nov 2023 - Data Toboggan 25th Nov 2023 - Data Bash October 2023 6th Oct 2023 - Microsoft Power Platform Conference September 2023 14th Sep 2023 - [Contact Us](https://datavibe.co.uk/contact/) ## Landing Pages - [Home](https://datavibe.co.uk/home/) - [About Data Vibe](https://datavibe.co.uk/about-data-vibe/) - [Speaking](https://datavibe.co.uk/speaking/) - [Contact](https://datavibe.co.uk/contact/) ## Categories - [Blog Post](https://datavibe.co.uk/category/blog-post/) ## Tags - [Power BI](https://datavibe.co.uk/tag/power-bi/) - [Model View](https://datavibe.co.uk/tag/model-view/) - [Summary](https://datavibe.co.uk/tag/summary/) - [DAX](https://datavibe.co.uk/tag/dax/) - [RANKX](https://datavibe.co.uk/tag/rankx/) - [Tips & Tricks](https://datavibe.co.uk/tag/tips-tricks/) - [What-If Parameter](https://datavibe.co.uk/tag/what-if-parameter/) - [R-Python](https://datavibe.co.uk/tag/r-python/) - [Career](https://datavibe.co.uk/tag/career/) - [Professional Development](https://datavibe.co.uk/tag/professional-development/) - [Career Advise](https://datavibe.co.uk/tag/career-advise/) - [storytelling](https://datavibe.co.uk/tag/storytelling/) - [data visualisation](https://datavibe.co.uk/tag/data-visualisation/) - [mental health](https://datavibe.co.uk/tag/mental-health/) - [personal development](https://datavibe.co.uk/tag/personal-development/) - [Learning](https://datavibe.co.uk/tag/learning/) - [Resources](https://datavibe.co.uk/tag/resources/) - [conditional formattiong](https://datavibe.co.uk/tag/conditional-formattiong/) - [Microsoft Fabric](https://datavibe.co.uk/tag/microsoft-fabric/) - [Lakehouse](https://datavibe.co.uk/tag/lakehouse/) - [SQL Server](https://datavibe.co.uk/tag/sql-server/) - [data modelling](https://datavibe.co.uk/tag/data-modelling/) - [DP600](https://datavibe.co.uk/tag/dp600/) - [Certification](https://datavibe.co.uk/tag/certification/) - [Real Time Intelligence](https://datavibe.co.uk/tag/real-time-intelligence/) - [Activator](https://datavibe.co.uk/tag/activator/) - [Data Engineering](https://datavibe.co.uk/tag/data-engineering/) - [SharePoint Picker](https://datavibe.co.uk/tag/sharepoint-picker/) - [FABCON Atlanta 2026](https://datavibe.co.uk/tag/fabcon-atlanta-2026/) - [Announcements](https://datavibe.co.uk/tag/announcements/) - [Fabric CLI](https://datavibe.co.uk/tag/fabric-cli/) - [Architecture](https://datavibe.co.uk/tag/architecture/) - [Best Practices](https://datavibe.co.uk/tag/best-practices/)