Refresh Problem

[OscarSuarez10]

Hello Im trying to refresh my data but I´m having the following problem:

But the data is correctly refreshed in the Query Editor and when I click close and apply to go back to the report the previous message appears, why refreshing works in the Query Edit but don´t in the report?. Please Help.

[Anonymous]

Hi,

scroll down and see which table is causing the problem, go to that table and try to find which step is causing error. If you scroll down you should see which step is it and then have a closer look on query editor.

daniel

[OscarSuarez10]

Hello I scrolled down and found this message but i don´t know what does it mean?

---

[Anonymous]

It basically means on table VPN E INVER TOTALES 7 JOB in column JOB you have more than one 0 which is not allowed.

You need to go to that table/ column and change it so column JOB doesn't contain any duplicates.

[OscarSuarez10 · Accepted solution]

The problem was that it was creating some relationships with other tables automatically and that amde some conlficts, but when I delete the relationships I could refresh the data correctly