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 dates and They are used to generate a visual displaying sales trends over the years.
On the line graph visual i tried using the dates from the Facts table as well as the dates from the Dates table. Same case when it comes to the filters (I use a date timeline) and both approaches seem to work fine on the desktop power bi.
The problem comes when i publish the report to trhe report sever which has a scheduled refresh running every day.
After each refresh , if i use the date table dates on the visual and the Fact table dates on the timeline filter, the visual become blank for some reason, if i use the fact table dates on the graphs and the the Dates table dates on the filter, all the values get grouped to the first date only (When i move the timeline to later dates it shows blank).
I could use the Facts tables dates on both ends but i need to be able to drill down on the report visuals and this becomes not possible with this approach.
Any idea what this may be caused by and the solutions?
Thank you.
