I have created a sharepoint list to show the 'timesheet periods' to users from Power BI report as these periods are different to regular periods.
Initially, i was facing problem as Power Bi was showing one day off from some of the dates which is resolved now in the data source (i.e. power bi data model and i can see the correct dates - see below)
But when i publish this on the server, the dates are automatically changing and showing one day off again for some of the periods. See below snapshot from the live power bi report.
Please help me to resolve this.
Thanks in advance!