Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Error with when published powerBI.

Hello, I managed to published my Dasboard. Everything when over nicely. However, when I try to click refresh on the following page:  1. Clicking on the refresh button   2. Error msg...
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    Have submitted this issue internal to confirm, would update here as soon as possible if there is any update about it.

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anthonylabuda's avatar
anthonylabuda
New Member
3 years ago

I have a similar issue... I received the following: 

{"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}}}

I have checked the column names, rebuilt the entire query and it still kicks back an error when it is published online but not on desktop

Royel's avatar
Royel
Super User
3 years ago

anthonylabuda in this error missing column is NEWQA[ccon]. If this column in your data source re-check it spelled correctly and make sure there is no extra space before of after. 

 

Another way you can try to create a sample report with only that table (NEWQA) and check same column column gives you error or not. 

 

to validate your data source connection in the service, you can try with some other table create and publish the report then do the refresh. This time your refresh should perform perfectly. If not resolve data source connection.