Forum Discussion
Error when trying to refresh - was working fine!
Microsoft EmployeeIt seems like you have a duplicate row(s) from something different (or different data) in your latest file. You can filter out that latest file to confirm everything is still working, but then you need to figure out why there is a duplicate. You can consider adding a Remove Duplicates step in your query to get rid of it (at column or table level), or you can update your DAX to ignore it. Hard to propose an exact solution w/o seeing the model or having more details.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
mahoneypat thank you for the quick response!
Where are you thinking there is a duplicate row? I have duplicate rows in the missingterms file (one row to count as a hire and one to count as a term). I have tried deleting the most recent files and am still getting the same error. Any other ideas or places to look?
Thanks again!I have also tried two other things:
- I deleted all relationships in the model to the file APBI - still getting the same error
- Copied the APBI query - that seems to be running okay but if I switch to that one I will have to recreate the calculated columns and 50+ measures on the copy
Does that help to narrow in on what the issue might be at all?
- mahoneypat
From what you described and the error message you saw, it looks like an issue with one of your calculated columns on the APBI table. Do any of them use the [Latest Month] measure? Start there if so. In any case, you can figure out which column by "coding out" each one by one. Turn the expression to code by putting // in front of it or /* ...*/ around it (your code is the ellipsis) if multiple lines. Before the comment, just have each return 1 or something ( my column = 1 //CALCULATE(... ). Try to refresh when each column is coded out to see which one is causing your problem.
Regards,
Pat
