Forum Discussion
Data Refresh
- 4 years ago
Anonymous : As Petur-Ruhl mentioned, you need to have premium capacity (either Premium Per Capacity - P1,P2 etc or Preimum Per user ($10 additional if you have pro) inorder to have refresh more than 8 times.
Power BI limits datasets on shared capacity to eight daily dataset refreshes. The eight time values are stored in the backend database and are based on the local time zone that was selected on the Dataset Settings page.
If you have neither 'premium per capacity' / embedded nor 'PPM', you will be limited to 8 refreshes per day. Unfortunately Sharepoint does not support direct query. If you want 5 minutes refresh, you need to move away from Sharepoint to any other data sources which supports direct query. Take a look at Dataverse.
If this post helps, then please consider Accepting it as the solution, Give Kudos to motivate the contributors.
Anonymous :
In "Import" mode you can set refresh only 24 times a day with minimum refresh period of 30 minutes. You can not have 5 minutes refresh. If you share more details , we can find a way to achiveve your goal. Is the connection type of your dataset "Import" ?
- Anonymous4 years agoNot applicable
Hi,
I get my data from sharepoint online list.I want to refresh my data,when an item created or modified in sharepoint.Thank you
- ponnusamy4 years agoSolution Supplier
Anonymous : As Petur-Ruhl mentioned, you need to have premium capacity (either Premium Per Capacity - P1,P2 etc or Preimum Per user ($10 additional if you have pro) inorder to have refresh more than 8 times.
Power BI limits datasets on shared capacity to eight daily dataset refreshes. The eight time values are stored in the backend database and are based on the local time zone that was selected on the Dataset Settings page.
If you have neither 'premium per capacity' / embedded nor 'PPM', you will be limited to 8 refreshes per day. Unfortunately Sharepoint does not support direct query. If you want 5 minutes refresh, you need to move away from Sharepoint to any other data sources which supports direct query. Take a look at Dataverse.
If this post helps, then please consider Accepting it as the solution, Give Kudos to motivate the contributors.