Forum Discussion

MadhavDholakia's avatar
2 years ago
Solved

Power BI Scheduled Refresh - Premium Per User License

Hello, 

I have a premium per user license and when I tried to schedule a refresh for one of the data source (3rd Party API using Web Method), I can only scheduled it for 8 times a day whereas I need this source refreshed every hour.

I am performing this action for the first time so not sure if there is anything else required to achieve this.

Can someone please help here?

Thank you.

 

 

 

  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    2 years ago

    Hi MadhavDholakia ,

     

    You need a ppu or premium capacity workspace then only you will be able to refresh more than 8 times.

     

    Thanks,

    Sai Teja 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi MadhavDholakia ,
    Thanks for SaiTejaTalasila reply.
    Here's what I'd like to add:
    For Power BI users, refreshing data typically means importing data from the original data sources into a semantic model, either based on a refresh schedule or on-demand. You can perform multiple semantic model refreshes daily, which might be necessary if the underlying source data changes frequently. Power BI limits semantic models on shared capacity to eight scheduled daily semantic model refreshes. The eight time values are stored in the backend database and are based on the local time zone that was selected on the Semantic model Settings page. The scheduler checks which model should be refreshed and at what time(s). The quota of eight refreshes resets daily at 12:01 a.m. local time.
    If the semantic model resides on a Premium capacity, you can schedule up to 48 refreshes per day in the semantic model settings. 
    Myworkspace can't allocate capacity for it, so it can only apply up to 8 refreshes

    Data refresh in Power BI - Power BI | Microsoft Learn

     

    Best regards,
    Albert He

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

3 Replies

  • ok so not sure if this is because my report and semantic model were in My Workspace? I created another workspace and added a copy of both report and semantic model, and then I was able to schedule refresh for every hour, i.e., more than 8 times a day.

    Thank you.

    • SaiTejaTalasila's avatar
      SaiTejaTalasila
      Super User

      Hi MadhavDholakia ,

       

      You need a ppu or premium capacity workspace then only you will be able to refresh more than 8 times.

       

      Thanks,

      Sai Teja 

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi MadhavDholakia ,
      Thanks for SaiTejaTalasila reply.
      Here's what I'd like to add:
      For Power BI users, refreshing data typically means importing data from the original data sources into a semantic model, either based on a refresh schedule or on-demand. You can perform multiple semantic model refreshes daily, which might be necessary if the underlying source data changes frequently. Power BI limits semantic models on shared capacity to eight scheduled daily semantic model refreshes. The eight time values are stored in the backend database and are based on the local time zone that was selected on the Semantic model Settings page. The scheduler checks which model should be refreshed and at what time(s). The quota of eight refreshes resets daily at 12:01 a.m. local time.
      If the semantic model resides on a Premium capacity, you can schedule up to 48 refreshes per day in the semantic model settings. 
      Myworkspace can't allocate capacity for it, so it can only apply up to 8 refreshes

      Data refresh in Power BI - Power BI | Microsoft Learn

       

      Best regards,
      Albert He

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