Forum Discussion
Error refreshing semantic model
- 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.
- 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)
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)