Forum Discussion
Best solution for Excel files as a source/Gateway/Refresh limit
Hi Applicable88 ,
If the dataset resides on a Premium capacity, you can schedule up to 48 refreshes per day in the dataset settings. For more information, see Configure scheduled refresh later in this article. Datasets on a Premium capacity with the XMLA endpoint enabled for read-write support unlimited refresh operations when configured programmatically with TMSL or PowerShell.
Please refer to the topic to see if it helps you.
Unable to schedule more than 8 refreshes with a "Premium per user" trial license
- Once assigned the App Workspace should have the PPU Icon as shown below.
- you can go into the dataset settings
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Applicable88
It sounds to me firstly that you will need Power BI Premium Per User or Premium if you want to refresh more than the 8 times with Power BI Pro!
Next back to your question, if the gateway can access the files then you can refresh the data via the gateway as often as you like. There is no need for office to be installed on the gateway server, because it just reads the contents of the file and does not actually open it on the gateway.
Hello GilbertQ , thanks for the reply.
We have powerbi pro license user, but we also have premium workspace. At least in the manual refresh schedule settings we can make up to 48 times per day. So i guess it counts as Premium license.
If the gateway is not influence by that, where to set the refresh intervall within the gateway software?
Best.