Bug Report: Power Query pulling incorrect dates from Salesforce

[QC]

I found this very strange issue today: I run a very simple Power Query (2 lines) to pull data from a SFDC report, as you can see from screeshot below Power Query automatically adds 1 day to both date fields. I couldn't figure out why!?

I am running the report in the morning so there is no time difference btw. UTC and local time. 

What is even more strange is that the issue only happens with certain reports, while other reports are ok. 

Please MS team help look into it. Thanks,

Version: 2.126.927.0 64-bit (February 2024)

[Anonymous]

Hi @QC 

Have you ever compared the difference between a report that shows normal time and one that doesn't?Are you creating additional measures or calculated columns in reports that are not displaying properly?

Best Regards,
Community Support Team _ Ailsa Tao

[QC]

Hi Alisa, for the report I am having issue with, I didn't create any calculated columns, it is a very basic report with native SFDC fields. I have other reports all work fine. It's very strange what happened with this particular report, which is realted to SF "Activity" module, "Tasks and Events" reporting template. The "created date" is supposed to be straightforward date when an "activity" was created (such as customer visit, etc.). Thanks

[Anonymous]

HI @QC 

Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

Best Regards,
Community Support Team _ Ailsa Tao