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 trying to import a table from Dataverse which has a Date only column. The problem is when I import the table the Date only column it displays an incorrect date in the power bi desktop, the date displayed is always one day less than the actual date. What should I do to display the correct date?
Thank you.
Solved! Go to Solution.
this its comuun problem of regional setting to corrrect this on the power query change the date time zon format first them make it back to date only format using the locale format something like this, but first elimate all any change typ auto that the query does when importing
Proud to be a Super User!
Hi @Youssef_haitham ,
Has your problem been solved? If it is solved, please mark a reply which is helpful to you.
If the problem is still not resolved, please follow the below steps to check TimeZone in Dataverse.
Once Done follow this video to change the same time zone in Power Query
https://www.youtube.com/watch?v=0f4-R3jQWRA
Best Regards,
Winniz
this its comuun problem of regional setting to corrrect this on the power query change the date time zon format first them make it back to date only format using the locale format something like this, but first elimate all any change typ auto that the query does when importing
Proud to be a Super User!
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 |
---|---|
106 | |
98 | |
80 | |
67 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |