Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

QC

Bug Report: Power Query pulling incorrect dates from Salesforce

Submitted by Kudo Kingpin on ‎02-21-2024 09:46 AM

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
See more ideas labeled with:
3 Comments (3 New)
Comments
Anonymous
Not applicable
‎02-22-2024 12:57 AM

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
‎02-22-2024 08:48 AM

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
Not applicable
‎02-27-2024 01:28 AM

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

Idea Statuses