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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |