Forum Discussion

bic's avatar
bic
New Member
1 year ago
Solved

Error refreshing semantic model

When trying to refresh a semantic model in a pipeline I get the follow error message:   "Data source error: The specified table '' not found in the target model."   There's no blank tables so I'm...
  • rohit1991's avatar
    1 year ago

    Hi bic ,

    The error message you're encountering—"Data source error: The specified table '' not found in the target model"—typically indicates that the semantic model (formerly known as a dataset) is trying to reference a table that either no longer exists in the source or was renamed or removed during development but not properly updated in the model schema. Even if no blank tables are visible in your model, there might be phantom references—such as calculated tables, relationships, or measures—that still point to a deleted or renamed table.

     

    To resolve this, open your model in Power BI Desktop and carefully check for any invalid references in the Model view, including unused queries, broken relationships, or DAX expressions referencing missing tables. Additionally, try refreshing the model locally to see if the same error persists—this can help narrow down whether the issue is in the Power BI Service or the model itself. Once you've cleaned up any orphaned elements, republish the model and re-run the pipeline refresh.

  • Jai-Rathinavel's avatar
    1 year ago

    bic  You might have renamed the Table name in desktop and might have published it to service. While setting up the enhanced refresh using pipeline in service you might have pointed it to your old Table name (Eg: Finance) . Now just repoint it to your latest table name (Eg: Financial)