MS Fabric

Can I test data in MS Fabric?

Can CAT Tests Data in MS Fabric?

Yes. CAT can tests data in your lakehouses, warehouses, semantic models. All of that is supported. You typically use SqlServer@2 provider or Dax@2 provider.

How do I run CAT from my MS Fabric Notebook?

Here comes a little surprise - it is not possible. CAT depends on successfully installed .NET 8 runtime. MS Fabric is “more managed” service than Azure Databricks. It does not allow running initialization scripts on the worker nodes.

But what is important - it does not matter at all. Because CAT is designed to verify your users work with correct numbers. From that perspective it does not make much sense to run the tests directly from MS Fabric. Tests such as

  • testing data in sources and reporting problems (e.g., data not ready)
  • incremental load correctness
  • all Power BI tests
  • any cross-system checks
  • and others.

Run the tests from some different place. Really. CAT is a whitness that all works as you designed it, end to end - it makes little sense to place it directly into MS Fabric.

← Databricks
Troubleshooting →