cache snapshot
2 Topics
Cache refresh without using scheduled refresh
Hi All, I am unsure if it is possible to do what I want to do however thought I would ask before re-engineering a large(ish) report. We pull data directly from D365 Online and surface this through various filtered tables and visuals to provide our leadership with data. Unfortunately, D365 online isn't supported for scheduled refresh therefore we are currently opening the report every day, refreshing the data and then saving it again. Anyone know if there is a way to refresh this cached data automatically from D365? My workaround failing this will be a scheduled data extract from D365 to SQL and then a scheduled refresh into PBI, however this is less than ideal as the D365 export isn't great 😞Solved1.2KViews0likes2Comments
PBIX report's Schedule refresh Vs Paginated report's Cache Snapshot scheduling on PBI Report Server
Hi Everyone, We're aware that , by using PBIX report's Schedule refresh feature on PBIRS, we can our refresh our report's data. But, coming to paginated report's Caching - the data is returned from the cache instead of running the dataset query again. But, we didn't understand how the Cache Snapshot scheduling process works on PBIRS. For example, I've a sales paginated report and I've a setup a cache snapshot schedule to run every 5 minutes. Here, I can see the report is getting refreshed every 5 minutes. So, every 5 mins is it hitting to its data source ? Please clarify my doubt. And kindly educate me to understand - how paginated report's Cache snapshot schedule works when compared with PBIX report's Schedule refresh feature on PBIRS. Thanks in advance !Solved3.2KViews0likes5Comments