Fabric Archives - Page 2 of 5 - Purple Frog Systems

Fabric Toolbox: A Helpful Resource for Exploring Fabric
March 5^th, 2026 in Blog, Community, Fabric, Microsoft Fabric
As Microsoft Fabric adoption grows, many businesses are starting to move beyond experimentation and into building production analytics platforms. However, implementing and managing a modern data platform still involves more than simply enabling the technology. To help teams get started and explore best practices, Microsoft and the wider community have introduced Fabric Toolbox, a collection of open source resources designed to support Microsoft…
» Read more
Part 1: Using the Companies House API
February 13^th, 2026 in Blog, Business Intelligence, CSV, Data analytics, Export, Fabric, Jupyter, Python, Visual Studio
The .gov website hosts companies house and the companies house API. This is a comprehensive list of businesses across the UK, new and old, big and small, and their filings and info. You can interact with this information via code such as Python. The following blog post series will show you how to perform an advanced search of companies – using multiple different filters to get specific businesses – and then looping through these results to…
» Read more
Back Up and Restore a Fabric Lakehouse
November 27^th, 2025 in Backup, Blog, Fabric, Restore Point
Fabric Lakehouses have been around for a while, but they still offer no native way to back them up or restore them. Fortunately, the way Lakehouses are structured makes it possible to build your own backup process. A Lakehouse is split into two areas: Files and Tables. The Files area is straightforward, you can download and back up these items directly. The Tables are powered by Delta tables, which are made up of two key components: the…
» Read more
Using Microsoft Fabric PySpark Notebooks to Combine Different File Formats Together
November 13^th, 2025 in Blog, Data Lakehouse, Fabric, Python
One of the strengths of Microsoft Fabric is how easily it handles different data formats within a single notebook. Whether your data arrives as a CSV file, a JSON file, an XML file, or anything in between, PySpark (or Python) gives you a consistent way to read, transform, and combine it. This makes Fabric an ideal environment for building data pipelines without relying on complex integrations. In this example, I’ve loaded three completely…
» Read more
Predictive Analytics for Small and Medium Enterprises
November 3^rd, 2025 in AI, Azure, Big Data, Blog, Business, Fabric
For many years, predictive analytics was a luxury reserved for large enterprises with deep pockets and advanced infrastructure. Today, thanks to the power of cloud computing, AI-driven tools, and accessible business intelligence platforms like Power BI, small and medium enterprises (SMEs) can tap into predictive analytics to transform how they plan and grow. At Purple Frog Systems, we’ve seen firsthand how even modest-sized organisations can…
» Read more
FabFest 2025: Running the Microsoft Fabric Clinic!
October 16^th, 2025 in Blog, Community, Data Lakehouse, Fabric, Microsoft Fabric, Power BI, Sponsoring Event
FabFest is a great community conference held in Birmingham, UK, that Purple Frog Systems has sponsored for the past 2 years. This year, we had the opportunity to host 2 clinics for attendees, where they could learn more about Microsoft Fabric or AI solutions, or troubleshoot issues currently faced in these areas. Why did we choose to run these clinics? At last year’s conference, we had several attendees approach us with questions about…
» Read more
Transform Your Data Strategy: Why You Should Migrate to Microsoft Fabric
March 24^th, 2025 in Blog, Fabric, Microsoft Fabric
Microsoft Fabric Migration offers several compelling benefits for organisations looking to enhance their data management and analytics capabilities 📊 Here are some key reasons why you should consider the transition: 1. Unified data ecosystem Microsoft Fabric consolidates diverse data toolsets into a single integrated service. This means you no longer need to juggle multiple tools and platforms. Fabric provides a comprehensive solution…
» Read more
Data Factory pipeline failure with a “null” error message
March 10^th, 2025 in ADFv2, Blog, Data Factory, Fabric, Synapse
Have you ever had this error when running a pipeline in ADF or Synapse? I have now seen this more than once and it can be frustrating to debug the issue. After trying a few different setups in Synapse I have found that the following scenarios all result in the same error: 1. An Until activity inside an If Condition 2. A nested ForEach activity 3. A parameter with “-” in the parameter name For 1 and 2 it is not possible to create…
» Read more
How to Effectively Restore a Table in a Fabric Warehouse
February 3^rd, 2025 in Backup, Blog, Fabric, Restore Point, Time Travel, Warehouse
If you’ve ever used a database, you’ve probably experienced that heart-jolting moment when you accidentally drop a table or run an update statement without a WHERE clause. In that instant, the table is either gone or potentially corrupted beyond repair. Fortunately, there are ways to recover data, depending on the environment you’re working in. In traditional databases like on-prem SQL Server, or other systems that rely on physical…
» Read more
Introducing Dynamic Execution of Fabric Pipelines: The Wait is Over!
January 28^th, 2025 in Blog, Fabric
For several years, it has been a limiting factor that Azure Data Factory (ADF) and Azure Synapse Analytics, and more recently Fabric, did not allow dynamic content to be passed into the invoked pipeline name within the Execute Pipeline activity. I’ve blogged about a workaround for this in Azure Synapse Analytics previously here:…
» Read more

Alex Whittles (MVP)
Annabel Hemingbrough
Callum Bryant
Hollie Whittles
James Snow
Jeet Kainth
Joe Billingham
Jon Fletcher
Laura Adamson
Lewis Prince (MVP)
Matt Mair-Durrant
Nick Edwards
Tom Owen