• Fabric Workspace Monitoring: What It Actually Shows You

    Fabric Workspace Monitoring: What It Actually Shows You Ever had a Fabric pipeline hang for no obvious reason, or watched a semantic model refresh crawl with no explanation? Fabric Workspace Monitoring is built for exactly that. Flip one toggle in workspace settings and Fabric spins up a read only Eventhouse, streaming execution logs, query text, CPU consumption, and error data into KQL tables you can query directly. Nothing to install, no…

    » Read more
  • Microsoft Fabric Warehouse Case Insensitive: Workspace Setting Guide

    A person wearing a Purple Frog Systems polo shirt stands in front of a stylised tech-themed background with hexagonal patterns and server racks. To the right, bold white text reads: ‘Microsoft Fabric Warehouse Case Insensitive: Workspace Setting Guide.

    Making a Microsoft Fabric Warehouse case insensitive is a decision you can make before building your data platform. If Customers does not equal customers in your queries, your Warehouse is case sensitive. The solution is simple. You just need to configure the correct setting at the Workspace level. Why Configure a Microsoft Fabric Warehouse Case Insensitive? In a case sensitive Warehouse, capitalisation matters: Sales is different from sales…

    » Read more
  • Underutilised Power BI Visuals (and When to Use Them)

    James wearing a black and purple Purple Frog Systems polo shirt, standing in front of a graphic background with hexagonal patterns and an image of hands working on a tablet. Text on the image reads: “Underutilised Power BI Visuals (and When to Use Them).

    Introduction Power BI provides many built-in visuals, plus custom options from the marketplace. Yet many reports still rely heavily on bar, column, and line charts. While those are effective, a few underutilised visuals can help tell richer stories and surface deeper insights. This post highlights some of them, explains when they add value, and offers guidance on using them thoughtfully. Decomposition Tree What it does: Lets you dynamically…

    » Read more
  • Variable Libraries In Microsoft Fabric, In Preview!

    In Preview: Variable Libraries in Microsoft Fabric Microsoft Fabric’s variable libraries offer a powerful way to streamline your CI/CD processes, especially when you’re working in a shared workspace. In this post, we’ll explore the key benefits of this feature and how it can boost your team’s productivity. What Are Variable Libraries in Microsoft Fabric? Variable libraries in Microsoft Fabric let you store and manage variables in a…

    » Read more
  • Metric Sets in Power BI

    Metric Sets In Power bi

    Metric Sets in Power BI: Transforming Data Management Having reliable and consistent metrics is crucial for making informed decisions. Microsoft Power BI has introduced an enhancement with the launch of Metric Sets, now available in public preview. This innovative feature is designed to help you define, discover, and reuse trusted metrics across your organisation. It enhances your data experience and empowers you with the tools you need to…

    » Read more
  • Connect Azure Data Studio to Microsoft Fabric

    Azure Data Studio and Microsoft Fabric As organisations increasingly adopt Microsoft Fabric for their data warehousing and analytics needs, finding the right tools to speed up development is crucial. Connecting Azure Data Studio to Microsoft Fabric can streamline your workflow, enabling you to navigate environments, pinpoint variances, release code, and assign memorable names to connections instead of relying on lengthy connection strings. Step…

    » Read more
  • Quick Guide to Transition Power BI Reports to Power BI Paginated Reports

    A Quick Start Guide to Transitioning Existing Power BI Reports to Power BI Paginated Reports Why move a PBI report to Paginated Reports? The Use Case of Paginated Reports Paginated reports offer powerful features that regular Power BI reports may not fully address. When you encounter requirements like print-ready documents or data grids that overflow across multiple pages, paginated reports are the solution. Here’s why they’re essential:…

    » Read more
  • How to manage relationships in Power BI Service!

    Managing Relationships Within Power BI Service. The feature to edit and open the Data Model in Power BI Service has introduced the ability to also manage relationships in this environment. This relatively new feature streamlines the process, saving time compared to making changes in Power BI Desktop and republishing. Getting Started Open your report in Power BI Service and click on “Edit.” Once in editing mode, access the “Open…

    » Read more
  • Power BI: Grouping & Binning using Data Groups

    In this blog, we explore Power BI’s Data Groups feature, enhancing data visualization and interaction for report users. Data Groups in Power BI: Power BI’s Data Groups efficiently organizes data. Compared to lengthier alternatives like grouping in Power Query or DAX Calculated Columns. Binning Data for Visualization: Let’s discuss data binning for clearer visuals. Binning categorizes data into bands or ranges. For instance in…

    » Read more