Forum Discussion
Power BI - Schedule refresh
By default, Power BI allows up to 8 scheduled refreshes per day for datasets in Power BI Pro. However, if you need to refresh your data more frequently than that, you can consider upgrading to Power BI Premium or Power BI Embedded, which provide more options for refreshing your data.
With Power BI Premium, you can set up refresh schedules as frequent as every 15 minutes or even trigger refreshes in real-time using DirectQuery or Live Connection.
Alternatively, you can also consider using Power Automate (formerly Microsoft Flow) to refresh your data more frequently. You can create a flow that refreshes your dataset at the desired frequency and triggers it using a timer or other trigger. Note that this approach requires a separate license for Power Automate.
In order to schedule refreshes, a data gateways must be connected. A refresh refreshes the content through the data gateway.
It definately not too chalenging. I would begin by looking into setting up an 'On Premises Data Gateway'. YouTube is your friend on this one!
Best of luck!
I've downloaded the on premises data gateway. I then logged into that with my power BI credentials. But it still fails to refresh, it says online.
Then in connectors, it says load custom connectors from this folder which is empty: C:\Users\PBIEgwService\Documents\Power BI Desktop\Custom Connectors. Is this a problem that it is empty?