Forum Discussion
Date changing when uploading to service
Solution SupplierHi jackperry61, you mention you have used an incremental refresh in the service? So the 1899 date could potentially be some old data that is persistent as it won't be affected by subsequent refreshes. Have you tried republishing the full report to the service so your desktop version 'overwrites' whatever is currently in the service? Do you need an incremental refresh?
Otherwise, it might be good to share how your incremental refresh has been set up. It feels like this may be the problem, rather than any DAX.
Good morning,
Sorry it was a long day yesterday - I just mean a scheduled refresh. Every time it is uploaded to the service it looks fine, but then if I refresh the data, or it refreshes at midnight when the schedule is set, the dates revert to 31/12/1899.
Thanks