Hi,
I'm experiencing an issue when building a report from power apps.
In power apps the date of activity column and the same column in powerbi are different. Once the data is pulled through into powerbi the date is -1 compared to that of the power apps, but this is also not consistent with it not happening all of the time.
For example :
Entry 1277 - Power Apps Date of Activity : 19/06/23
Entry 1277 - Powerbi Date of Activity : 18/06/2023
This is causing issues because we are going to be audited on this information and so the dates can't be incorrect. If it was consistent then I could just create a column and DATEADD, but due to the inconsistency I can't just apply this as a solution.
I've got no idea why this is the case, but I need a solution urgently.
Any help would be greatly appreciated thankyou.
