Forum Discussion
Solved
Data refresh from mixed sources
My report uses a combined query in the qruey editor from: Db with directquery 2 online excel files The max refresh rate trough the enterprise gateway currtenly is 8 times/day. Is there...
Hi RikMertens ,
By my tests with the combined data source below, it seems that we only could set the schedule refresh for Daily and Weekly in Power BI Service.
- SQL Server Database
- excel in bussiness OneDrive
If you want to refresh the data source for more than 8 times/day, you may try Premium capacity.
In addtion, you could refer to this blog which should be helpful.
Best Regards,
Cherry
Hi RikMertens ,
By my tests with the combined data source below, it seems that we only could set the schedule refresh for Daily and Weekly in Power BI Service.
- SQL Server Database
- excel in bussiness OneDrive
If you want to refresh the data source for more than 8 times/day, you may try Premium capacity.
In addtion, you could refer to this blog which should be helpful.
Best Regards,
Cherry