Forum Discussion
Scheduled Refresh Errors with the Dates
Hi Everyone, I have a Fact table with some sales data and a date column and a separate date Table created in DAX with the CALENDARAUTO(). The tables are linked together in the data model by the date...
change your filters to account for the service UTC.
Recommendation is to use the dimension columns for the axis. In your case the Dates table date. The facts table date column should be hidden.
I tried this today and it looks fine on the power bi desktop and even after i publish it to thhe report server
The problem comes when the scheduled refresh runs, the visuals which have the date from the date table as the axis become blank, any idea what might be the reason?