Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Refresh Now in Power BI Service

Hi community,   This one got me thinking and afterwards got me jumping once i read a little more into it.   So i am trying to undertand, which of our users are able to select the 'Refresh Now' bu...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    Whenever you refresh data in a dataset, whether by using Refresh Now or by setting up a refresh schedule, Power BI uses information in the dataset to connect to the data sources defined for it, query for updated data, and then loads the updated data into the dataset. You can refer to the online document.

     

    What's more, you can use refreh now to refresh the datset more that  8 times per day. In othe word, that will not consume the times limit. 

     

    Regards,

    Frank

     

  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymousv-frfei-msft

     

    Thank you both for your reply!

     

    After some more research and testing i also answered the below.

     

    Anyone in the Workpsace only has access to the Datasets, hence the Refresh Now button, if this is enable in the 'Edit Workspace' tab. you need to ensure: Memebers can only view Power BI Content. This will automatically disable users from being able to click the Refresh Now button. However, i will explore the Apps more.

     

    In regards to the 'Refresh Now' button consuming the datasets 8 refreses per day. This is not the case, as i have a dataset scheduled to be refreshed 8 times a day, within that i also refreshed multiple times and they all completed successfully:

     

     Scheduled21/11/2018, 20:30:0321/11/2018, 20:40:39 Completed
     Scheduled21/11/2018, 18:30:0321/11/2018, 18:37:45Completed 
     Scheduled21/11/2018, 17:30:0421/11/2018, 17:36:50Completed 
     Scheduled21/11/2018, 16:30:0621/11/2018, 16:37:12Completed 
     On demand21/11/2018, 16:27:4721/11/2018, 16:29:04Completed 
     On demand21/11/2018, 15:31:3421/11/2018, 15:33:16Completed 
     Scheduled21/11/2018, 14:30:0621/11/2018, 14:36:48Completed 
     On demand21/11/2018, 14:16:5021/11/2018, 14:18:55Completed 
     Scheduled21/11/2018, 13:30:1121/11/2018, 13:41:16Completed 
     On demand21/11/2018, 13:27:0221/11/2018, 13:28:17Completed 
     On demand21/11/2018, 13:21:3221/11/2018, 13:22:50Completed 
     Scheduled21/11/2018, 12:30:1221/11/2018, 12:40:19Completed 
     On demand21/11/2018, 11:49:2421/11/2018, 11:50:39Completed 
     On demand21/11/2018, 11:37:1921/11/2018, 11:38:51Completed 
     Scheduled21/11/2018, 10:30:0821/11/2018, 10:43:59Completed

     

    Thanks,

    Laz

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous,

 

Whenever you refresh data in a dataset, whether by using Refresh Now or by setting up a refresh schedule, Power BI uses information in the dataset to connect to the data sources defined for it, query for updated data, and then loads the updated data into the dataset. You can refer to the online document.

 

What's more, you can use refreh now to refresh the datset more that  8 times per day. In othe word, that will not consume the times limit. 

 

Regards,

Frank

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymousv-frfei-msft

     

    Thank you both for your reply!

     

    After some more research and testing i also answered the below.

     

    Anyone in the Workpsace only has access to the Datasets, hence the Refresh Now button, if this is enable in the 'Edit Workspace' tab. you need to ensure: Memebers can only view Power BI Content. This will automatically disable users from being able to click the Refresh Now button. However, i will explore the Apps more.

     

    In regards to the 'Refresh Now' button consuming the datasets 8 refreses per day. This is not the case, as i have a dataset scheduled to be refreshed 8 times a day, within that i also refreshed multiple times and they all completed successfully:

     

     Scheduled21/11/2018, 20:30:0321/11/2018, 20:40:39 Completed
     Scheduled21/11/2018, 18:30:0321/11/2018, 18:37:45Completed 
     Scheduled21/11/2018, 17:30:0421/11/2018, 17:36:50Completed 
     Scheduled21/11/2018, 16:30:0621/11/2018, 16:37:12Completed 
     On demand21/11/2018, 16:27:4721/11/2018, 16:29:04Completed 
     On demand21/11/2018, 15:31:3421/11/2018, 15:33:16Completed 
     Scheduled21/11/2018, 14:30:0621/11/2018, 14:36:48Completed 
     On demand21/11/2018, 14:16:5021/11/2018, 14:18:55Completed 
     Scheduled21/11/2018, 13:30:1121/11/2018, 13:41:16Completed 
     On demand21/11/2018, 13:27:0221/11/2018, 13:28:17Completed 
     On demand21/11/2018, 13:21:3221/11/2018, 13:22:50Completed 
     Scheduled21/11/2018, 12:30:1221/11/2018, 12:40:19Completed 
     On demand21/11/2018, 11:49:2421/11/2018, 11:50:39Completed 
     On demand21/11/2018, 11:37:1921/11/2018, 11:38:51Completed 
     Scheduled21/11/2018, 10:30:0821/11/2018, 10:43:59Completed

     

    Thanks,

    Laz

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      7 years ago

      Hi Anonymous,

       

      Did you have any other question? If no, kindly mark my answer as a solution to close the case please.

       

      Regards,

      Frank