Forum Discussion

Dayna's avatar
Dayna
Helper V
4 years ago
Solved

Differing rows between the online Dataflow and Desktop Power Query Editor

Hi All,   I've got a really strange issue... I have a dataflow called 'Accounts' which I'm loading into my report, I've recently made a few changes to the dataflow by adding key fields, etc. and en...
Need Help
  • Dayna's avatar
    Dayna
    4 years ago

    I ended up raising a ticket with Microsoft for this and in summary, they think something went wrong with the dataflow merge and the resolution was to recreate it, as when exported to JSON, it was fine. 

Dayna's avatar
Dayna
Helper V
4 years ago

I do have a schedule refresh, think it sets the timezone to be UTC...! Could this be the problem? 

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi Dayna ,

 

1. What is the version of Desktop you are using?

2. Are the two rows you are loading in Desktop duplicate values? If they are duplicate, is the date of this duplicate row the archived date (i.e. last 5 years) or the incremental refreshed data (i.e. last 3 months)? As far as I know, even with incremental refresh, what you see in the dataflow are still the data between RangeStart and RangeEnd, not all date. So the possible reason for the inconsistent data seen in the dataflow and Desktop is that the archived date and incremental refreshed date set for the incremental refresh override the parameters range.

3. What is your data source? Is this situation for all data sources or for one?

4. If your data does not contain sensitive data, could you share the .json file of your dataflow?

 

Best Regards,
Winniz