Forum Discussion

Post Patron

5 years ago

Solved

Refresh error wrong

I got error on refresh Data source error: {"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{...

Need Help

Show and Tell

Tips and Tricks

v-kelly-msft
5 years ago
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!

Digger

Post Patron

5 years ago

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

Super User

5 years ago

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
Post Patron
5 years ago
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
- Pragati11
  Super User
  5 years ago
  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
    Post Patron
    5 years ago
    Pragati11 how i can find if i didnt see any error in desktop file?
- jdbuchanan71
  Super User
  5 years ago
  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
    Post Patron
    5 years ago
    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