Forum Discussion

jimpatel's avatar
jimpatel
Post Patron
2 years ago
Solved

Refresh failure

Hi,   Thanks for looking at my post. We having power bi portal and few reports were working fine, but suddently some of the reports fallen apart. When i try to refresh manually in the desktop versi...
Need Help
  • ibarrau's avatar
    ibarrau
    2 years ago

    Hi. The error is here because there was a wrong manual entry data. If you check the message it's trying to convert 0054-23 to number. That's not a number. The best solution is talking with the people/users that entry data for the source to let them know there is wrong value on their data. Explain which table and column has the wrong value. If they just don't care and won't change it, you can replace those scenarios with empty or 0 depending the calculations of the data model and let them be aware of the change with an email (evidence that you have asked for the best way and they didn't but you need to go through this).

    That should fix it again. Data entry can be the worst kind of errors that can break semantic models.

    I hope that helps,

jimpatel's avatar
jimpatel
Post Patron
2 years ago

Thanks a lot for your reply

 

Issue is that is not only one number throwing an error but when i fix that in SQL side, new similar number throwing same error

 

Thanks 

  • ibarrau's avatar
    ibarrau
    Super User
    2 years ago

    That's bad. That's why the first and best solution is the source. The users loading the data. Only when you can't make them understand the importance of the data entry is when you need to start thinking about the approach like "when you find a - then 0". That rule should be autorized by the sponsor or final user of the report.

    Regards