Refresh Error

[alevandenes]

Hi,

I have an issue with one of my reports. I tried to refresh the data behind it, but it gives me this error:

Does anyone knows how to exactly find out what it is going on in the background?

I read posts about this, but i cant seem to understand where i need to look to correct the error 

[more than one table has this error - not just SALES]

I really would like to avoid building the report from scratch, so any suggestion is very welcome.

Kind regards,

Alessandra

[amitchandak · Accepted solution]

@alevandenes , Ther can be a few reasons. Open Data Transformation/edit query mode and check do you get a detailed error .

If so try to address that.

Refer if these can also help

https://www.youtube.com/watch?v=bmKYOiJt4EM

https://www.youtube.com/watch?v=iVY1GkiYs-U

[alevandenes]

I love this community! Thank you!
I have reviewed all the columns of my tables and trasformed them in the right data type and refresh now works!