Forum Discussion
Error when trying to refresh - was working fine!
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
Microsoft Employee
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
mahoneypat thanks for the idea! I tried using the mycolumn = 1 //CALCULATE on all of my calculated columns in the APBI table and am still getting the same error when I try to refresh. The only thing using LatestMonth is the measure LatestMonth and is not referred to by other measures or columns. Double checked using the method described here: https://exceleratorbi.com.au/measure-dependencies-power-bi/
Any other ideas to troubleshoot?
- mahoneypat
Other than a simple close and reopen of your file, no more ideas at the moment.
Regards,
Pat
