change in schema version
1 Topic
Semantic Model Refresh Error - "Reported a change in schema version"
I'm getting this error during scheduled refreshes: "The OLE DB provider \"MSOLEDBSQL\" for linked server \"ServerName\" reported a change in schema version between compile time (\"CompileTime\") and run time (\"RunTime\") for table \"\"DatabaseName\".\"dbo\".\"TableName\"\"."}}" Background: TableName is updated and reindexed nightly, but the process completes hours before the refresh. Using SQL Server 2019. Steps I’ve Tried: Restarting the on-prem gateway service after reindexing. Restarting the entire server. Updating Power BI queries from SELECT * to specific column selections. Any advice on resolving this error?Solved1.6KViews0likes3Comments