Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Direct Query Caching Issue

We're doing some work with a newer system and have it setup to put data into a database that will be used to modify and update calculations inside some pbi visuals.  The visuals will have:   A mas...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Anonymous ,

     

    This blog may help you:

    https://www.credera.com/insights/power-bi-directquery-automatically-refresh-less-than-every-15-minutes/ 

    Or try to get the page refreshing while the report is in Full Screen mode:

    1. Set the URL with the string ā€œ?chromeless=1ā€ added to the end.
    2. Use the Super Auto Refresh extension to schedule a refresh interval
    3. Set your browser in Full Screen mode by pressing F11.

     

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

lbendlin's avatar
lbendlin
Super User
5 years ago

Have you played with the Auto Page refresh feature for Direct Query sources?  That seems to discard the cache.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yeah I was messing around with those, but didn't know that the min limits are different on shared capacity with the workspace, that was throwing me off target.  Thanks for the info. šŸ™‚