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: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Dates from Amazon Forecast loading incorrectly

‎06-25-2020 08:04 AM

I have a sales forecast dataset produced by Amazon Forecast which has date-time stamps in the format YYYY-MM-DDTHH:MM:SSZ (for example, 2015-02-01T00:00:00Z). For some reason, PowerBI is loading the dates wrong, specifically, one day backward. For example, a date of 2015-02-01 in the csv fie is being loaded as January 31, 2015.  Any idea why?

Labels:
Message 1 of 3
293 Views
0
1 ACCEPTED SOLUTION
Anonymous
Not applicable
In response to parry2k

‎06-25-2020 08:49 AM

I found the solution. By default PowerBI was loading the date as date format. I changed to text format and trimed off the text to the right of "T" so that 2015-02-01T00:00:00Z would be 2015-02-01. Now the date is correct.

View solution in original post

Message 3 of 3
270 Views
0
2 REPLIES 2
parry2k
Super User
Super User

‎06-25-2020 08:12 AM

@Anonymous seems like it is related to the timezone that is part of the timestamp, check if this post helps.

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 2 of 3
288 Views
0
Anonymous
Not applicable
In response to parry2k

‎06-25-2020 08:49 AM

I found the solution. By default PowerBI was loading the date as date format. I changed to text format and trimed off the text to the right of "T" so that 2015-02-01T00:00:00Z would be 2015-02-01. Now the date is correct.

Message 3 of 3
271 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

View All