Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Frequently refreshing and publishing using PowerBI Desktop

Hi. Hypothetically, would it be okay to refresh and publish a PBI report every 20 minutes from PowerBI Desktop, if we are using PowerBI Pro to view the report? For example, what if I had a plant operator refresh and publish a report every 20 minutes during his/her shift (automation aside)? 

 

The PBI report queries several tables on two MSSQL databases (import not DirectQuery). If refreshing and publishing from the Desktop program, the queries would be performed by the local computer. Would MS have any issue with this, given the use of a shared capacity without PowerBI Premium? 

 

Thank you.

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

Hi @Anonymous

it be okay to refresh and publish a PBI report every 20 minutes from PowerBI Desktop with pro account.

But it needs you to do that manually.

You can also publish the reports to the Service and set up schedule refresh with a data gateway. Finally the refresh job will be done automatically.

But with this method without premium capacity, If your dataset is imported,dataset is refreshed up 8 times a day; 

If your dataset is configured for a live or DirectQuery connection, datasets are refreshed approximately each hour or when interaction with the data occurs. You can manually adjust the refresh frequency in the Scheduled cache refresh option in the Power BI service.

 

Please read links below to know more.

refresh in power bi 

Configuring scheduled refresh

https://biinsight.com/refreshing-on-prem-sql-server-database-on-power-bi-using-power-bi-personal-gateway/

 

Best Regards

Maggie

 

 

 

LivioLanzo
Solution Sage
Solution Sage

@Anonymous

 

I think that would be possible if it does not get too repetitive on your side having to manually refresh and publish the report each 20 minutes

 

 

 


 


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


Proud to be a Datanaut!  

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors