Refresh Only Certain Tables

[Anonymous]

Hi,

I have a dataset in Power BI Service that I refresh daily. One of the tables I refresh in this report does not need to be refreshed daily, but the others do. To cut down on compute cost, I'd like to refresh the other tables but not this one. Is this functionality possible? 

[ibarrau]

Hi. Yes it is, but with a cost asociated. You can only refresh like that datasets in Power BI Premium, Premium per user, and Power BI Embedded. If you have a workspace with capacity then you can use this specific request of API:

https://docs.microsoft.com/en-us/power-bi/connect-data/asynchronous-refresh

The request will let you define the objects you want to refresh. Then you probably need a cloud space to run it and schedule it like Automation Runbooks or Azure Functions. You can also run it on premise but you will depend on the PC/VM turned on to trigger.

I hope that helps,

[Anonymous]

Unfortunately I only have a Power BI Pro license, thank you though!