Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am working with a custom sharepoint list that I have connected to with Power BI Desktop. The connection is fine and the data is loading into the table. However, the created column is changing the time of day of the record from what is listed in the sharepoint list. For example, a record that was created at 8:00 AM is showing as 1:00 PM in Power BI.
I have confirmed that the data is storing correctly in the sharepoint list by exporting it to excel. Included below are two screen shots. One from excel showing the created date and time as well as the ID number of the record, the second is a screenshot of the data from PowerBI. Same records, same ID numbers, but different times of day listed in the created field.
I searched for any similar posts but couldn't find any.
As always, any help is greatly appreciated.
Thank you,
PTalbott
Solved! Go to Solution.
This might be caused by UTC time zone. You may refer to the following thread to add a new column.
http://community.powerbi.com/t5/Desktop/Dashboard-date-not-reverting-from-IST-to-PST/m-p/341337
This might be caused by UTC time zone. You may refer to the following thread to add a new column.
http://community.powerbi.com/t5/Desktop/Dashboard-date-not-reverting-from-IST-to-PST/m-p/341337
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |