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,

ibarrau's avatar
ibarrau
Super User
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,