Forum Discussion
Refresh Only Certain Tables
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 lik...
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,
Unfortunately I only have a Power BI Pro license, thank you though!