Forum Discussion
Error in dataflow refresh
While working on dataflow, it's difficult to say when will it show error as for my case it didn't showed up any error in query. but showed up error after refresh. till now i was able to debug it but ...
Most likely the error does not show up in the query before full refresh, as then only the first 1000 rows are tested, and the error might be happening in a later row.
if the error message doesn't show you which table is the problematic one, I'd suggest you to create another dataflow where you change the tables one by one, then see after refreshing which one you get the same error, then you'll know within which table the error resides, and look for the faulty data entry within the table then.
cel download i am getting excel from which I am getting table have error.
