Forum Discussion
Data Refresh - Import Method
Hi all,
We have developer a dashboard by importing datasets from multiple datasources.
Our requirement is to refresh the datasets every 10minutes.
Is it possible to refresh data sets(Import Method) every 10minutes.(microsoft document says that via import method we can refresh datasets hourly and only 8 times a day).
Thanks
revansh The UI only supports the import refresh as the documentation states. If you have an 8 minutes requirement you would need to combine your dataset behind the scenes into a source that supports Direct Query, or into a model that is a Live Connection. In both those scenerio's you would have some scheduled job that refreshed the dataset.
You "might" be able to refresh certain dashboard tiles using the Developer API but that is outside my expertise area. I'm not aware of a way to refresh a dataset using the Dev API's.
4 Replies
revansh The UI only supports the import refresh as the documentation states. If you have an 8 minutes requirement you would need to combine your dataset behind the scenes into a source that supports Direct Query, or into a model that is a Live Connection. In both those scenerio's you would have some scheduled job that refreshed the dataset.
You "might" be able to refresh certain dashboard tiles using the Developer API but that is outside my expertise area. I'm not aware of a way to refresh a dataset using the Dev API's.
Eno1978,
Thanks for the reply.
We are trying to see if there are any proved workarounds.
Can we add multiple scheduled refreshes on the same data model. for ex: add schedule1 to start at 9.00AM to run every hour...
similarly add schedule2,schedule3,schedule4,schdule5 and schedule6 to start at 9.10, 9.20,9.30,9.40 and 9.50 respectively. This way the data model refreshes every 10minutes,
Thanks
revansh If you need a refresh exactly every 8 minutes or 10 minutes - Import is not the solution.
The scheduled refresh as it stands does not execute exactly at the time you set it. It is more of a "Within that hour" refresh.
From my understanding the Service attempts to execute the refresh in 15 minutes of the set time, but I've had multiple clients where it can take even longer than that.
If you need constantly updated data, you need to pursue the other options I listed in my previous post.
Seth, can you elaborate on combining a dataset into a source that supports direct query or live connection? I'd really like to display the dashboards I have created in Power BI full-screen on TV's around my workplace, in a live connection mode or refreshed every 5 minutes at the most.
