Unanswered

1 day difference in saved date between Power BI and Power Apps (and Dataverse)

(0) Share

Report

Posted on by Wimpy

I am building an app where you can use the date picker to save a date that I save in Dataverse. Power Apps and Dataverse show the correct date, but when I connected Dataverse to the Power BI report, I noticed that Power BI always shows one day less. So when I saved May 24, Power Apps and Dataverse return May 24, but Power BI shows May 23. I thought this might be a time zone issue, but I couldn't figure out where to change the time zone in Power BI, and I don't even work with date times, only dates.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

When you patch use this or if your using a form make this the update
DateAdd(DatePicker.SelectedDate, -1, Days)

If that makes the date wrong in dataverse then just use that to display the date in PowerApps as you can confirm that it is correct in dataverse. Other than this you would have to check timezone settings.
Wimpy 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your answer.
I would prefer to solve the problem and then just use the form if it is unavoidable. Can you tell me where I can find the time zone settings? I have already searched for them and could not find them...
callumbeveridg2 2 on at

Like
a
(0)

Report
Copy link

Link copied!

The issue is related to time zones. You're entering date via powerapps, which defaults the time element to midnight (all dates/datetime have a time element). When this is stored in the underlying 'database', it's stored as UTC time, so gets converted.

In my case, UK BST (UTC+1), when picking a date of 30th June, it creates it as 30th June 00:00:00 and stores that as 29th June 23:00:00 in the underlying UTC database. Powerapps converts this back into my local time when displaying it - so there's no issue there.

However, when reading this time via, say N52, or Synapse, the time is retrieved in UTC format. In our case, the Synapse link puts the date into the datalake in UTC format, but we pull it into our data warehouse and strip the timezone info off the date format (SQL Datetime2 field), and so cannot display the date in PowerBI using the users local timezone.
The fix to to run a localtime conversion on all dates when retrieving them for use with powerBI

Rgrds
Callum