Zenzero
Zenzero
Guernsey
Jersey
United Arab Emirates
United Kingdom

Microsoft Fabric known issues

9th June 2024

Microsoft Fabric is a powerful, unified analytics platform, but like any evolving technology, it comes with its own share of issues and glitches. Understanding these can help your company avoid common frustrations and implement features more smoothly, ensuring efficient data operations.

Here’s an overview of Fabric’s key issues and Microsoft’s recommended workarounds. For expert support, the certified Zenzero Microsoft Fabric Services team is always available to assist.

 

Dataflows Gen2 Refresh Performance

Refreshing a Dataflow Gen2 with CI/CD (Continuous Integration and Continuous Deployment) might be slow or time out unexpectedly.

Impact: This can severely compromise real-time reporting and dashboard reliability.

Workaround: Create a new Dataflow Gen2 with CI/CD and wait 10 minutes before refreshing again in the same workspace.

 

Real-Time Intelligence Instability

The Real-Time Intelligence feature is known to present the following issues :

  • Publishing eventstreams (real-time data pipelines that ingest, process, and route streaming data) can fail due to connector errors.
  • Duplicate item names cause digital twin builder failures.
  • Capacity metrics and the Explore mode sometimes show inaccurate or blank data.

Impact: These glitches hinder real-time monitoring and automation, disrupting time-sensitive operations.

Workaround: Use unique names for digital twin builder assets and verify published eventstreams before relying on them for automation or alerts.

 

Power BI Dataflow Gen2 Publishing Failures

Dataflows with a default destination to Azure SQL are failing to publish.

Impact: This disrupts automated data processing pipelines and could delay Power BI reports or analytics workflows.

Workaround: Remove the default Azure SQL destination and replace it with a standard destination.

Disabled SQL Database Errors

When disabled, some SQL databases show an error message such as, “This SQL database has been disabled. Please reach out to your Fabric Capacity administrator.”

Impact: The issue can block data access, disrupt critical workloads, and create governance headaches.

Workaround: Pause your capacity and wait 15 minutes before resuming. This should reset all affected SQL database items back to their active state.

 

OneLake Shortcut Creation and Read Errors

Users are encountering “bad request” errors when creating or reading OneLake shortcuts. Deleted shortcuts sometimes still appear as empty files.

Impact: Since OneLake is core to unified data access in Fabric, errors or delays create confusion, duplication risks, and disrupted pipelines. It can also hinder cross-workload data integration.

There is currently no suggested workaround.

 

Spark Job Failures in Data Engineering

The following problems with Spark jobs have been reported:

  • Spark jobs fail with out-of-memory errors when working with timestamp data.
  • Activity monitoring pages are sometimes blank for T-SQL notebooks.
  • Some jobs fail silently or misreport success/failure.

Impact: Data engineering tasks depend on stable Spark job execution and proper visibility. Failures cause delays and data inconsistencies.

Workarounds: Optimise Spark configurations, especially when working with large timestamp datasets, and avoid relying solely on visual job monitors.

 

Service Principal API Failures in Data Engineering

When working in your Lakehouse, you can use shortcuts with variables. When using service principals for public API calls, the calls fail if the shortcut payloads include variables. This relates specifically to executing operations like Git imports/updates or deployment pipelines.

Impact: The issue negatively impacts automated deployments and CI/CD pipelines.

Workaround: Utilise user authentication when employing variables for your Git or deployment pipeline operations.

 

FAQs

Are some Microsoft Fabric features still limited?

Yes, some features like full Git integration, advanced Power BI controls, and regional availability of certain services are still evolving and not fully available.

Why does Microsoft Fabric have so many issues?

Microsoft Fabric is an ambitious and relatively new (2023) platform that integrates multiple services under one umbrella. These include data science, data engineering, warehousing, real-time analytics, and business intelligence. Given the innovation and complex integration that Microsoft Fabric supports, some growing pains are inevitable as the platform matures and services stabilise.

How can I stay updated on known issues and fixes?

Microsoft maintains a Fabric known issues page that’s regularly updated. It’s a good idea to check it before deploying new features or if you encounter functionality problems.

Discover more from Zenzero

Subscribe now to keep reading and get access to the full archive.

Continue reading