cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Laz Member
Member

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' button in PBI Service under the tab 'Datasets'? I initally thought they would need to be configured as a user in the data source of the Gateway, but i was wrong as i tested with a user who wasnt added in the Gateway data source user panel and was able to click 'Refresh Now'.

 

Does anyone have an article that explain any of this in more detail?

 

Also, i know with Power BI Pro license, we are limited to 8 refreshes per day when importing data. The key questions (concern) i have is... If users click 'Refresh Now', does this use up the available 8 refreshes per day?

 

Thank you All,

 

Laz

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: Refresh Now in Power BI Service

Hi @Laz,

 

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. 

Capture.PNG

 

Regards,

Frank

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Laz Member
Member

Re: Refresh Now in Power BI Service

@Ross73312@v-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

4 REPLIES 4
Ross73312 Super Contributor
Super Contributor

Re: Refresh Now in Power BI Service

Anyone who is a workspace member has access to the Refresh Now button.  If you want people to only have consumer access to your reports, i'd suggest using the Publish App button and giving them access through that area only.

 

The refresh now button will consume that dataset's 8 per day limit.  This limit is extended to 48 times per day with premium.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


Community Support Team
Community Support Team

Re: Refresh Now in Power BI Service

Hi @Laz,

 

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. 

Capture.PNG

 

Regards,

Frank

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Laz Member
Member

Re: Refresh Now in Power BI Service

@Ross73312@v-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

Community Support Team
Community Support Team

Re: Refresh Now in Power BI Service

Hi @Laz,

 

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

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 57 members 1,113 guests
Please welcome our newest community members: