Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have created a report and used a date slicer so that the users can select the date range of the data that they wish to view. eg a quarter. I have defined which reports the date range will work across.
However, I get an issue (cannot replicate myself but it happens) whereby when the report is refreshed at a future point, the report appears to hold the old dates used for previous searching and will not display new data. I created a report and it was used to search for dates upto 31st March 2019. Now when I run a refresh, new data from April 2019 onwards is appearing in the "Edit query" section but I cannot get the new data to appear/update the existing reports - to get the new data to appear I have to create a new report. Creating a new page in the existing report does not work. It is like the date range used previously is "stuck" in the reports memory/cache (?) and therefore new data will not be used as it is not meeting the "old" date range. This renders the reports blank and pointless.
I have deleted the data range filter, removed all filters, refreshed multiple times, reviewed the new data in Edit query so know it is in the data model, but I cannot get new data to pull through onto existing reports!! VERY FRUSTRATING!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.