Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 like to refresh the other tables but not this one. Is this functionality possible? 

Need Help

2 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

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