Imported date from Dataverse is not correct

[Youssef_haitham]

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.

[v-kkf-msft]

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

[StefanoGrimaldi · Accepted 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