Forum Discussion

Digger's avatar
Digger
Icon for Post Patron rankPost 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's avatar
    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!

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

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's avatar
Digger
Icon for Post Patron rankPost 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's avatar
    Pragati11
    Icon for Super User rankSuper 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's avatar
      Digger
      Icon for Post Patron rankPost 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's avatar
        Pragati11
        Icon for Super User rankSuper 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