Issue with Power BI(Data View)

[GolakotiSiva]

Im having an issue with Power BI as the dates in the Data model view and sharepoint data are different as its showing (-1) date in data mode view (Example share point(12/03/2023) Data model(11/03/2023)).

I'm also attaching the snapshots of issue please help me.

[Anonymous]

Hi @GolakotiSiva ,

We are unable to do a reproduction of this problem based on the image you provided. Does the problem occur in Power BI Desktop or in Service? Would you mind providing the detailed steps to reproduce it?

Best Regards,
Community Support Team _ Caitlyn

[GolakotiSiva]

My issue is I'm facing in Power BI issue, I have sharepoint dataset that dataset is connected to Power BI, after connecting sharepoint dataset I'm having issue i.e (the date column in Power BI "Data View"  showing (-1) date to sharepoint dataset Date column) .

Example like in sharepoint, I have dataset date column in that date column we have date "13/3/2023" after connecting sharepoint dataset to power BI the date column is showing as  "12/3/2023".

Please find the atached dataset view of sharepoint and Power BI Data view model.

[FK3]

Curious to know what date type shows for the column in the query editor. On the left is date/time, with a clock on top of a calendar icon. On the right is date/time/timezone shown as a clock on top of a globe.

Also, is your data type in the model date or date/time?

[GolakotiSiva]

Please find below attachment what the Date column have data type in my data view