Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Values in Slicer not refreshing with Data Refresh

I'm running a simple report that uses xls files in a sharepoint folder as source data. The user then is to filter the data by selecting which file to use from a slicer. The first couple weeks I was d...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    I truly appreciate such a quick response. I did investigate the source data as you mentioned and realized a nuance on Power Query filters that I didn't know before.

    To limit the sheer volume of data that this query will call as time goes on I filtered the xls file sources to only the files that had been modified in the last 30 days. At the report level in the PBIX filters have the option to "include today." That's not so in the Power Query. I then added a layer to the filter to catch the files where [modified] 'in the last' [30 days] OR [modified] 'is' [today].

     

    This doesn't answer why the screengrab I showed included the file that was added/modified today whereas the slicer did not. But adding that OR statement to include [Today] solved the problem.

v-yinliw-msft's avatar
v-yinliw-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Anonymous ,

 

You mentioned that your data source is the xls files in the sharepoint folder and the data source refresh was good before.

I think in the case of guaranteeing that there is no problem with the refresh, you need to check the table of the data source whether there is a pivot table, if there is, you can try to clean up the cache of the pivot table.

PivotTable options, in data, change the Number of items... from Automatic on None, and refresh.

 

Hope this helps you.

 

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.