Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to 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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
141 | |
70 | |
70 | |
53 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |