refresh schedule more frequently than 30 minutes

[maurcoll]

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

[MFelix · Accepted solution]

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.