Data Refresh - Import Method

[revansh]

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

[Seth_C_Bauer · Accepted solution]

@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.

[Sabatino]

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.

[revansh]

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

[Seth_C_Bauer]

@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.