Salesforce dates all April

[mikeotaylor]

Hi

New to this so apologies for the clumsy posting.

I've just pulled a Salesforce report into BI desktop and all the dates are reverting to 1 April. So, rather than being able to visualise by month or quarter, I can only go by year.

Is there an explanation for why all dates are coming through as April when pulled from the report?

Thanks!

MIke

[mikeotaylor]

My bad. I realise now that it was because of the way my report was set up. I was grouping results by year, and so only results by year were being picked up by BI.

[lbendlin]

please post a sanitized version of your Power Query code.