Forum Discussion
Auto Refresh in Dataset
I understand your explanation, but the point is, if there is an option that allows you to update on demand, why not allow it to be scheduled? That is the question. I can update on demand from minute to minute.
Because every refresh requires Microsoft servers to work. Direct Query does not. So MS limits it to 30 minute intervals to prevent their servers from being overloaded by the millions of users that use Power BI. To get below 30 minute intervals, you have to use Direct Query.
That's the way it is. Sorry. To do what you want, 100% in the cloud, you'd need an Azure SQL table, the write a small Power Apps front end to it to allow your users to update it. Then write a Direct Query report on top of it. ¯\_(ツ)_/¯
And the On Demand is there largely for testing. Not for users to get new data.
bout it. My account is PRO. We can not migrate to a SQL Server. Countless people use the sharepoint list to update information all the time. I did not want to have to use a javascript, map the refresh on demand option. I wanted something more simple and functional. Sharepoint is part of Microsoft's tools. I do not understand why there is not a refresh with less time.
Because with a direct query, the refresh is really happening at the server level. Sharepoint cannot do that, nor can Excel files, or other similar Microsoft solutions. SQL Server has its own processing engine.
If they allowed 5min refreshes with unlimited refreshes per day. MS would need to spend tens of millions on upgrading their servers and cloud services that support Power BI to handle the workload.
But they don't care what you do to your servers, which is why they support direct query for data sets that need essentially live data. But the source has to have its own engine, as SQL Server, Oracle, Azure SQL, and a few dozen others do. Sharepoint does not.
edhans wrote:
bout it. My account is PRO. We can not migrate to a SQL Server. Countless people use the sharepoint list to update information all the time. I did not want to have to use a javascript, map the refresh on demand option. I wanted something more simple and functional. Sharepoint is part of Microsoft's tools. I do not understand why there is not a refresh with less time.
Because with a direct query, the refresh is really happening at the server level. Sharepoint cannot do that, nor can Excel files, or other similar Microsoft solutions. SQL Server has its own processing engine.
If they allowed 5min refreshes with unlimited refreshes per day. MS would need to spend tens of millions on upgrading their servers and cloud services that support Power BI to handle the workload.
But they don't care what you do to your servers, which is why they support direct query for data sets that need essentially live data. But the source has to have its own engine, as SQL Server, Oracle, Azure SQL, and a few dozen others do. Sharepoint does not.
I understand your explanation, but the point is, if there is an option that allows you to update on demand, why not allow it to be scheduled? That is the question. I can update on demand from minute to minute.
I understand your explanation, but the point is, if there is an option that allows you to update on demand, why not allow it to be scheduled? That is the question. I can update on demand from minute to minute.
Because every refresh requires Microsoft servers to work. Direct Query does not. So MS limits it to 30 minute intervals to prevent their servers from being overloaded by the millions of users that use Power BI. To get below 30 minute intervals, you have to use Direct Query.
That's the way it is. Sorry. To do what you want, 100% in the cloud, you'd need an Azure SQL table, the write a small Power Apps front end to it to allow your users to update it. Then write a Direct Query report on top of it. ¯\_(ツ)_/¯
And the On Demand is there largely for testing. Not for users to get new data.