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.

     
     
     
     
v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
6 months ago

Thankyou, Vinodh247 for your response.

Hi NovaBI,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solution provided by Vinodh247to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.