Forum Discussion

NovaBI's avatar
NovaBI
Post Patron
6 months ago
Solved

Refresh error Gen 2 CI/CD: Mashup Exception Data Source Error

Hello,   since today, all Dataflows Gen 2 that do not use a SQL Endpoint failed.   If i go through the tables that are ingested into the flow, everything is shown correctly.   I already tried t...
Need Help
  • Vinodh247's avatar
    Vinodh247
    6 months ago

    You do not need table IDs. Delete tables by name.

    Fastest options:

    • Lakehouse UI: Open lakehouse -> Tables -> select table -> Delete (recommended).

    • SQL endpoint: DROP TABLE IF EXISTS dbo.table_name; 

    • Spark (if catalog is broken):spark.sql("DROP TABLE IF EXISTS table_name")

       

     

    After deletion, rerun the Dataflow Gen2 so Fabric recreates the table and fixes the catalog.

     
     
     
     
Vinodh247's avatar
Vinodh247
Super User
6 months ago

This is almost certainly a Fabric serviceside regression or backend change affecting DataflowsGen2 lakehouse table creation, not your data or mashup logic. The key signal is “Unable to create a table on the Lakehouse SQL catalog” while previews work and SQL Endpoint based flows succeed. That points to a failure in the lakehouse metadata or SQL catalog sync layer that Gen2 uses during refresh, especially when staging is involved. This has happened before during Fabric backend updates. Your mitigation options are limited: retry later, switch temporarily to SQL Endpoint ingestion where possible, or recreate the target tables in the lakehouse to force metadata realignment. If this started today across multiple flows, raise a Microsoft support ticket immediately and check the Fabric Service Health dashboard; do not spend time refactoring mashups, it will not help.

NovaBI's avatar
NovaBI
Post Patron
6 months ago

Vinodh247 ,

 

thanks for the imput. How do I delete the tables in the lakehouse?

Do I need to identify them via Id?