Forum Discussion
Subscription preview image filter update
It's a pretty standard pattern, but it requires the calendar table to be in import mode (or a calculated table) and the dataset to be refreshed daily-ish.
- Create a calculated column that marks the appropriate rows in the calendar table as "current month" and all others as the string representation of their month
- use that column in the slicer
- set the "current month" value as the default
- publish the report.
thank you lutz_bendlin I had this assumption as I already tested every step which can take place before, I was hoping that it is not related to the sql endpoint syncing... I will create a scenario and test it. Do you think it is the same with the datawarehouse...?
our data is updated; what is the issue is the refresh of the report which is not automatically done by the subscription. Will try with a ticket to Microsoft.