Refresh Some but Not All Data Sources in a Report

[TD21]

I have a report that pulls data from different data sources. Can I refresh them at different frequency? Example, can I refresh data source 1 daily, data source 2 weekly, data source 3 ad-hoc, without having to refresh all data sources every time I refresh the report? Thanks.

[v-yinliw-msft]

Hi @TD21 ,

You can set the refresh time you need in the setting of the dataset you need to refresh.

For example, turn on the Scheduled refresh  and choose the refresh frequency what you need, and also you can add another time below.

This way to set the refresh is that you can set different refresh times for different datasets, and the datasets with different connection methods are slightly different,

and you can view the following documents for the specific refresh methods.

Data refresh in Power BI - Power BI | Microsoft Learn

Hope this helps you.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TD21]

@v-yinliw-msft I know how to refresh a dataset. What I'm hoping to do is refresh only part of the dataset (say, 2 out of 10 tables).

[mariussve1]

Did you try the enhanced refresh feature I posted earlier?

Marius

[TD21]

@mariussve1 I did. Thank you very much!

[mariussve1 · Accepted solution]

Yes, this can be done. Then you need to use Enhanced refresh with Rest API. This can be done from power automate, azure data factory, powershell and so on.

Then you can setup refresh at any time, and you can refresh whole dataset, one table or even a single partition if you have incremental refresh.

You can also have a power automate button in the Power BI report if you want end users to have possibilities to trigger a refresh.

https://powerbi.microsoft.com/en-za/blog/enhanced-refresh-with-the-power-bi-rest-api-is-now-generall...

br

Marius