Forum Discussion

Digger's avatar
Digger
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":[{"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.

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!

14 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    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
    Super 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
      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's avatar
        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

  • edhans's avatar
    edhans
    Community Champion
    5 years ago

    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.