Refresh error wrong

[Digger]

I got error on refresh

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

But in desktop version i dont have any errors, also error does not show me where it raised.

So how to fix this error if i dont know where to find it?

As i chechked each table and each step, and everything is good there.

[v-kelly-msft · Accepted solution]

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,
Kelly

Did I answer your question? Mark my reply as a solution!

[edhans]

@Digger can you verify your gateway is on the latest version? I've seen weird errors like this when the gateway is 2-3 months behind. 

[Digger]

@edhans all latest versions

[Pragati11]

Hi @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

[Digger]

@Pragati11 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

[Digger]

@Pragati11  it is near 100 tables, 60 has this column, but no errors in desktop file, it first time published to web, there are no version without errors

[jdbuchanan71]

@Digger 

If you do a refresh on your powerbi desktop file to re-pull all the data from the sources, does that give any error?  Is it possible there was a column in a source when you originally connected to it by now it is missing so the errors when the web tries to refresh perhaps?

[Digger]

No error at all in desktop version, i guest what problem with 

Table.PromoteHeaders(#"Removed Top Rows1", [PromoteAllScalars=true])

as only this step produce column names

[Pragati11]

HI @Digger ,

I would suggest then checking all the visuals on the report specially the filters - if there are any filters on any of the visuals with this missing column.

I am hoping this should be doable.

Also, what datasource are you using to connect to these tables? Are you sure that nothing has changed in the source side regarding the structure of these tables?

In such errors, 99% the issue is in the source from where the data is coming in Power BI if no columns have been removed specifically in Power BI.

Thanks,

Pragati

[Digger]

@Pragati11 how i can find if i didnt see any error in desktop file?

[Pragati11]

Hi @Digger ,

I think I mentioned in my previous response - 

"I would suggest then checking all the visuals on the report specially the filters - if there are any filters on any of the visuals with this missing column." (visual level filters)

Visual level filter erros are sometimes not shown.

Thanks,

Pragati

[Digger]

@Pragati11  me too "As i chechked each table and each step, and everything is good there." and visual too

[Pragati11]

Hi @Digger ,

So you have checked all the visual level filters in Power BI Desktop?

I am assuming you are also confident with the source data that nothing has changed there.

Then it is tricky. Can you try re-publishing the report as I can't think of any other way of identifying this issue.

Thanks,

Pragati