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.
Alright. I have some additional insight. I was able to isolate the query and step causing the problem. It is a pivot function:
= Table.Pivot(#"Removed Position Columns", List.Distinct(#"Removed Position Columns"[Field]), "Field", "Value")
Again, I confirmed there were no errors in the results from this step or the prior step. I mocked up some data below with two scenarios that could (maybe?) be causing the issue. Is there something different in the way the service engine processes this compared to the desktop engine?
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.