Forum Discussion

stiggrr87's avatar
stiggrr87
Icon for Helper I rankHelper I
6 months ago
Solved

Dataset gives error for old deleted tables and columns

Hello,   This has happened too many times. When trying to refresh dataset or use data factory pipelines then I get error that some tables are missing. Or some columns are missing. But they were som...
Need Help
  • v-menakakota's avatar
    v-menakakota
    6 months ago

    Hi stiggrr87,
    Thanks for reaching out to the Microsoft fabric community forum. 

     

    Since it shows “No results found” for tables, this looks like a metadata sync problem between the pipeline and the semantic model, not just a missing column/table. The pipeline is unable to read the model schema.

    You can try re-selecting the semantic model in the activity and clicking Refresh to reload the tables. Also, consider deleting and recreating the refresh activity, as pipelines sometimes cache old metadata.

    If the issue still persists, the quickest fix is to re-publish the dataset and reconnect it to the pipeline, as this usually resolves any stale or broken metadata references.


    If I misunderstand your needs or you still have problems on it, please feel free to let us know. 

    Best Regards, 
    Community Support Team

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
6 months ago

Hi stiggrr87 

 

If you could please double check that your data source is not having any connectivity issues when refreshing the semantic model or your pipelines which could be causing the error.