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.
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:
The mass dataset is backed by a Synapse on-demand instance and we have that set to import in. The 'settings' data is currently in a AzureSQL db, and we have that setup for direct query.
Our issue is that we need the 'settings' data to be as near real-time as possible, or have some way an end-user (ISV embedding scenario) can hit a button to get new data. What's currently happening is it gets queried and lays around in cache for an indeterminant amount of time. As I write this, I keep going to a test report I setup just pulling the current db table and it's still reading half hour old data, even though I setup Scheduled Data Cache Refresh to 15 minutes.
Any options?
Solved! Go to Solution.
Hi @Anonymous ,
This blog may help you:
Or try to get the page refreshing while the report is in Full Screen mode:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
This blog may help you:
Or try to get the page refreshing while the report is in Full Screen mode:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That's extremely helpful. That link is super interesting. We might implement a user button to refresh for now, that would certianly be a good fix for this until we can do change detection on paid capacity.
Thank you for the input, super helpful. 🙂
Have you played with the Auto Page refresh feature for Direct Query sources? That seems to discard the cache.
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. 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
1 | |
1 | |
1 |