Forum Discussion

mikeotaylor's avatar
mikeotaylor
New Member
3 years ago

Salesforce dates all April

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

2 Replies

  • please post a sanitized version of your Power Query code.

  • 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.