Forum Discussion
Dataset refresh via Power Automate Flow - clarifications
Hi mollycat ,
Unfortunately, there’s no sneaky way around this one in Premium capacity, anything that refreshes your dataset via Power Automate (or any other API) does count toward the 48-per-day limit for that dataset, even if you trigger it manually with a button inside the report. The only refreshes that don’t count are when you (or someone with permission) click REFRESH NOW in the Power BI Service. The good news is you can add a Power Automate button in the report so end users can kick off a refresh themselves it just means each click will still eat into that 48-refresh daily quota. If you really need more than 48 automated/API refreshes a day, the only real workaround today is to go through the XMLA endpoint, which doesn’t have the same cap.
More details here in Microsoft’s official documentation: Data refresh in Power BI - Power BI | Microsoft Learn
Hope that clears things up. If the above solution works for you, please accept it as the solution so that other community members with similar issues can benefit.
Regards,
Akhil.
Amazing, thank you SO much Anonymous, this is extremely helpful!
Hello Anonymous, I've done some additional research in the time from our last exchange and have a few more questions, if you don't mind 🙂
- This report was actually set up originally in Direct Query mode to avoid the need for the refresh schedule consideration. When in Import mode, the data refresh takes about 20 seconds, which I'm assuming would be similar to load the data via Direct Query. However, the time it takes to reload the report visual (a Matrix and some filters) is extremely slow...making the report basically unusable. I'm wondering if pivoting back to Direct Query is worthwhile if there is a way to improve the report visual reload performance?
- If not, and the best method is to move forward with Import mode (again, semantic model refresh is very fast, so that is not a limitation), do you know if any of the Fabric features that are currently in preview mode may help solve this? I'm looking at Refresh a Semantic Model Using Data Pipelines (Preview) - Power BI | Microsoft Learn and, while I'm open to the XMLA endpoint, I wonder if something out of the box will be more sustainable longterm, assuming of course that this would allow 48+ refreshes.
Thank you, Akhil!