Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data Refresh

Hi all, Even though I have a pro account, I can't refresh my data more than 8 times a day with power automate. I added a power automate button manually, but I couldn't solve my problem that way. I s...
  • ponnusamy's avatar
    ponnusamy
    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.