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

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.