Scheduled Refresh - Different Tables with different update frequencies within a dataset

[Maeaex1]

Dear Community,

I have a PowerBI dataset (import mode as I run complex measures) where some tables need just a daily refresh, while for some smaller tables it might make sense to update them more frequently (e.g. every hour). 

Is it possible to schedule data refreshes somehow on table level within a dataset or can I just update the whole dataset? I didn't find anything in the internet about this.

Thanks for your help!

Best

Max

[lbendlin · Accepted solution]

No, this is not possible via scheduled refresh.  However, you can use an XMLA tool of your choice to selectively refresh individual tables.  The Enhanced Refresh API also allows you to specify tables  (sadly partitions are not working yet)  so you can do that with a custom connector in Power Automate, for example.

Datasets - Refresh Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn