Forum Discussion

Pooja-B's avatar
Pooja-B
Regular Visitor
3 years ago

Need Help to solve the Issue in Dates

Hello All!     I created a new report in Power BI which have the source data is from Sharepoint. In sharepoint Date has "13-Feb-2023". In Power BI data Table shows "12-Feb-2023" that is -1 from th...
Need Help
Pooja-B's avatar
Pooja-B
Regular Visitor
3 years ago

Hi AnkitKukreja ,
 Thank you so much for your response.
 I tried the Using Locale in Power query but its not working for me. Can you help me to solved out this issue.

In SharePoint I have the 1st date as "16-01-2023"
In Power BI it shows "15-01-2023"
By using the "Using Locale" it shows the same date. For your reference kindly view this image.

Thanks in advance,
Pooja-B

AnkitKukreja's avatar
AnkitKukreja
Icon for Super User rankSuper User
3 years ago

Hi Pooja-B 

 

A couple of things are you using the latest PBI Desktop version? Also, can you check in your source step if you are using SP v2.0?

Also, as Power BI generally pulls data in UTC can you change this column to Data/Time/Timezone and see if you see any offset? If yes, then try to change the timezone in SP again Setting proper SharePoint Time Zone for users | SharePoint Maven.