Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Bug Report: Power Query pulling incorrect dates from Salesforce

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)

 

Capture.JPG

Status: Investigating

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

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

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
Kudo Kingpin
Kudo Kingpin

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

v-yetao1-msft
Community Support
Status changed to: Investigating

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