Blog

  • Fabric Trials: The Countdown Is On

    We are drawing near to the end of Microsoft Fabric trials! ⌛ With the countdown ending mid-June for many trial capacities, it is important that you take measures to protect any Microsoft Fabric resources you have. Microsoft have informed users that once the trial ends, the capacity will be converted to a Power BI Premium capacity where Fabric items can no longer be used or stored. From here, you will have a 7 day retention period before all…

    » Read more
  • How to call Microsoft Fabric Data Pipelines dynamically using APIs

    The Microsoft Fabric REST APIs allow you to automate Fabric procedures and processes. In this blog post, we’ll focus on a specific API: “Run On Demand Item Job” To dynamically call another data pipeline, we’ll utilise this API within a data pipeline web activity. By passing in the itemId of the data pipeline we want to invoke, we can trigger its execution. You can learn more here:…

    » Read more
  • Getting To Grips With Copilot Chatbots

    Chatbots are becoming an essential part of many businesses and organizations, as they can provide instant and personalized responses to customers and employees, reduce costs and workload, and improve customer satisfaction and loyalty. However, creating a chatbot that can handle complex and natural conversations is not an easy task. It requires a lot of data, skills, and resources to design, develop, and deploy a chatbot that can meet the…

    » Read more
  • SQLBits 2024: Learning about people at a technical event

    SQLBits 2024 Learning about people at a technical event

    It has been a hot minute since I attended a SQLBits conference. It’s a techie event! I’m not technical. Project Managers must surely be classed as ‘persona non-grata’. Last year the team went, and I took a holiday. All those people in one place and guess which one of us came back with Covid? Typical. So, this year, trying to reduce my chances of a fourth bout, and with more ‘non-technical’ sessions available at the conference, it…

    » 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
  • Microsoft Fabric Mirroring: Quick Start Guide

    Mirroring provides a modern approach to accessing and ingesting data continuously and seamlessly from any database or data warehouse into the Data Warehousing experience within Microsoft Fabric. Here are the key points about Mirroring: Near Real-Time Data Access: Mirroring allows users to access changes in the source data almost instantly. It ensures that the data in Fabric’s OneLake remains up-to-date without complex setup or manual…

    » Read more
  • New Microsoft Fabric Features – A SQLBits and FabCon Round Up!

    March was a big month for Microsoft Fabric and its users as there were two major conferences discussing all aspects of Microsoft Fabric, from functionality to security and governance. SQLBits, a community conference, came first with a wealth of knowledge from experts using Microsoft Fabric from a beginner to experienced level. FabCon immediately followed, which was a conference from Microsoft to announce new features and to hear from those…

    » Read more
  • Behind the Scenes: My Perspective as a Speaker at SQLBits

    Behind the Scenes My Perspective as a Speaker at SQLBits

    SQLBits, the renowned conference for data professionals, brought together a diverse range of speakers this year, including four from Purple Frog Systems: myself, Lewis, Hollie, and Alex. Each of us tackled a variety of sessions, contributing our unique perspectives to the event. I spoke on two topics, both in the non-technical category about blogging and why it’s important to be creative in technical roles. First-time speaker nerves……

    » Read more
  • Using Stored Procedure as a Power BI Source (with parameters)

    Using a SQL Server stored procedure as a source in Power BI We might be most familiar with using a view as the source to our PBI datasets, a series of views creating a series of tables. This can be great but when handling more complex view queries with lookups, you might find yourself with a severely long refresh and even an error. This is where a stored procedure is required – this gives you more control layer by layer in the source query.…

    » Read more
  • Deployment Pipelines in Power BI and Fabric

    Deployment Pipelines in Power BI and Fabric were released in public preview way back in May 2020 and then made Generally Available in September 2020. Even with how long they have been out, I rarely see them talked about when they are a very handy tool for Developers to ensure reports and Fabric content are safely moved between workspaces. Plus it provides some helpful tools for collaborating with other developers. Let’s look into how…

    » Read more