Forum Discussion
Scheduled Refresh Fails While Desktop Refresh Succeeds
I discovered a workaround by adding replace null with "" across all columns (in the step before the pivot). The only null values were in the Value column, and there were only a handful. Later in the query, I reversed it by replacing "" with null.
Someone will need to explain to me one day how the service and desktop engines differ. What a pain.
Hi regerror6 ,
I have had this problem before as well. First thing to note is that the Service engine and the Desktop engine are not the same and therefore the Service will sometimes kick out some things that the Desktop does not. So, the way I have found this in the past when I have lots of columns and/or I don't know where this is from is to create a table visual and put in all of the fields and then do a sort by each one (yes, one at a time, but in the table it is just click and wait). And then, the "nulls" will be at the top OR, if this error is correct, you will get a field that says "Error" on it. Painful but sometimes that is the only way.
Thanks! I had the same though earlier. I rechecked the tables using your method and the column quality/profile tools in Power Query, and there were no errors.
I did not menion earlier, but my largest table only has ~200 rows (currently)—fairly low volume.