Forum Discussion

weslegal's avatar
weslegal
New Member
6 years ago

Query Filter

Have I a report that uses direct query.  One of the filters on the data is "month is in    "this month""    When the month changes the reports do not change to new month of data.  When on Power Bi D...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
6 years ago
Hi there

You would need to make sure that which ever column you have for "month is in "this month"" is getting updated for the changes to happen.

You could use a relative Date Slicer on the date column which could also work?
weslegal's avatar
weslegal
New Member
6 years ago

this is data that gets changed daily with todays date.  They is definetely data for the next month wich should be the current month but is not until I republish.  I could use a slicer but that would cause alot more data to get retrieved every time the report is run.

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi,

     

    Would you please check the scheduled cache refresh interval ?  I suggest you clear the browser cache and try again.

     

     

     

    Any changes to the underlying data will not be immediately reflected in any existing visuals. It is still necessary to Refresh, whereupon the necessary queries will be resent for each visual, and the visual updated as necessary.

     

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

     

    Best Regards,

    Dedmon Dai

    • weslegal's avatar
      weslegal
      New Member
      6 years ago

      It is not a cache problem  All of the other data in the report changes as expected, Just not the Current Month.