Refreshing a report, with dataset

[Unicorn_Tech]

Hello.  I've created a report for users, pulling data from Dynamics CRM.  When we click the "Refresh" button below, it only refreshes the information based on what had been already daily synced.  To do a full refresh, like if data inside the CRM changed, I have to first manually refresh the dataset, and only then does the refresh here work.

Can you advise a way for my users to be able to fully and immediately refresh the report, once they've made changes within the CRM.

[Anonymous]

If it is a PowerBI Report, you likely need to schedule a refresh on the report for it to update the cached data from the defined data sources.  If you want users to see changes in-near real time, you could potentially schedule a refresh to occur quite frequently.  This could possibly cause performance impacts to your report server and Dynamics CRM source depending on the complexity and amount of data the report is pulling.  You could also change the data source within the report to live query the data instead of cache it (if this is possible with a Dynamics CRM source).

[Unicorn_Tech]

Hi @Anonymous .  Thanks for the reply.  It seems the most frequently I would be able to update the report is daily - do you know a way that refreshes could be scheduled for three times a day, perhaps? 

[Anonymous · Accepted solution]