Forum Discussion
Issue while reusing existing table/query
Hey danishwahab ,
I have seen this error sometimes when I open a file in Desktop and the file has not yet "loaded" all of the queries. What I have to do is let all the queries load (and ensure that they have all loaded in the Power Query editor side) and then hit refresh and it works fine. This does not always happen and it doesn't always kick back on the same query, but the "steps not complete" and the "rebuild" are consistent.
let me know if waiting it out actually helps!
Thanks collinq for your response.
In my case, there is absolutely no issues in the Desktop. I'm able to refresh individual tables/queries and final report however this error comes only when refreshing a published report on the Report Server.
Thanks!
Hey danishwahab ,
Thanks for the clarification, I misunderstood and thought the issue was in Desktop. I did read the answer from Anonymous . I agree with you though that this can get cumbersome.
I am wondering if you have confirmed that every single data field has a data type that is NOT "any"?
What about the Section1/LocationTypeMaster/ field specifically?
Also, do you have a merge or two where the issue might be coming from?
I am wondering if instead of redoing the whole thing if you can move the step up or down and get around the issue???
The issue isn’t with datatypes. The problem arises when referring to another table as a source, which causes the scheduled refresh to fail on the server after deployment. However, the refresh works fine on the desktop.
Thanks!
