Forum Discussion
PBI Service Refresh fails but desktop does not
I have checked the source, code and rebuilt the entire qury - it refreshes on the desktop but not the service..
The detailed code is
{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","details":[{"code":"ModelRefresh_DataSourceErrorLabel","detail":{"type":1,"value":"Expression.Error: The column '<ccon>ID' of the table wasn't found.. ID. <\/ccon>. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: NEWQA."}},{"code":"ClusterUriText","detail":{"type":1,"value":"WABI-US-NORTH-CENTRAL-G-PRIMARY-redirect.analysis.windows.net"}},{"code":"ActivityIdText","detail":{"type":1,"value":"b5fb8280-6ca2-4bc5-b235-274df81bff41"}},{"code":"RequestIdText","detail":{"type":1,"value":"4e406718-c826-25b5-2dbf-43110c1df9b9"}},{"code":"TimestampText","detail":{"type":1,"value":"2023-08-11 12:39:25Z"}}],"exceptionCulprit":1}}}
5 Replies
Hey Antony, try to go to the power query, in the specific table of this error and click on refresh visualization, I imagine that the data must be in cache and therefore not updating, according to the error it is not finding the ID column in the NEWQA table.
I have tried that and even added a custom column with that name to prevent the error and its still occurring
- sulleyinoz
Advocate II
Hi Anthony,
This might be related to this issue reported a couple of days ago if it used to refresh and has now stopped with no changes.
