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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
maurcoll
Helper III
Helper III

refresh schedule more frequently than 30 minutes

Hi

 

I have a report in Power BI service that i need to refresh more frequently than every 30 minutes which currently is all i can do. I have a Power BI Pro license and the data is coming from a data warehouse into a report and then published to Power BI Service.
Is there a way to schedule the data to refresh more frequently, it is an extremely large dataset and i have not been able to use direct query as i get an error stating it cannot preview the data, i think there are more rows than can be used in direct query.

 

Thank you

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @maurcoll ,

 

Having a Power BI Pro license you cannot have an automation to have more than the 8 times per day, even if you do a power Automate that will count to a Schedulle refresh count since it uses the API.

 

For this I would use the Direct Query has you refe, concerning the staging error for not preview data I would do a SQL query with a TOPN has a parameter this would allow to have the stagging and preview on the Desktop then on the service I would change the parameter to be blank that way would pick up all the data you need.


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

1 REPLY 1
MFelix
Super User
Super User

Hi @maurcoll ,

 

Having a Power BI Pro license you cannot have an automation to have more than the 8 times per day, even if you do a power Automate that will count to a Schedulle refresh count since it uses the API.

 

For this I would use the Direct Query has you refe, concerning the staging error for not preview data I would do a SQL query with a TOPN has a parameter this would allow to have the stagging and preview on the Desktop then on the service I would change the parameter to be blank that way would pick up all the data you need.


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.