Forum Discussion
Imported date from Dataverse is not correct
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.
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
2 Replies
- StefanoGrimaldi
Resident Rockstar
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
v-kkf-msftCommunity Support
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.
- Navigate to https://make.powerapps.com
- Click Gear icon at the top
- Select Advance settings
- Once Page Loaded Click Gear Icon at the top, select Options.
- Select Personalization settings --> Change the TimeZone based on your needs
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