Forum Discussion
Post PatronRefresh error wrong
Hi Digger ,
If desktop works fine,then try to republish the dataset to another workspace with a new name and check whether this error still exists.
If not,then back to the oringinal workspace,delete the dataset and republish it again.
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
Super UserHi Digger ,
The error below clealry says, one of the column is missing from your table:
Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"The column 'total_sale_amount' of the table wasn't found."}}],"exceptionCulprit":1}}}
I would suggest you check your table if this column is missing or not.
Thanks,
Pragati
DiggerPragati11 not clearly it not say in which place, As i checked each table and each step, and everything is good there. no missed columns!!!
- Pragati11
Hi Digger ,
How many tables have you got in Power BI?
The error seems very straight forward, just that you will have to check which one is missing this column.
Have you got any previous versions of this report, where this error never appeared?
You can do a quick search under FIELDS PANE for this column in the previous report.
Also just checking spplied steps in Query editor doesn't confirm everything is fine as this column may have been deleted in the source from where you are accessing these tables.
Thanks,
Pragati