Power BI Fact table refersh

Hi anusha_2023 ,

Here are my thoughts and I hope they help: 

1. Refreshing the Semantic Model More Than 8 Times a Day:
With a Power BI Pro license, you are limited to 8 refreshes per day. To exceed this limit, you would need a Power BI Premium subscription. However, there are some workarounds, such as creating multiple copies of the dataset and scheduling them at different times.

2. Power Automate Subscription Needed:
For your team of two developers with F4 Fabric capacity and Power BI Pro licenses, you would need the Power Automate Premium subscription. This plan costs $15.00 per user/month. This should be sufficient for building the flows you need.

3. Power Automate Premium for Developers:
Yes, purchasing two Power Automate Premium subscriptions for your developers should be enough to build and manage the required flows. This plan includes access to premium connectors and other advanced features necessary for your automation tasks.

4. Using Power Automate to Resolve API Limitation:
Power Automate can help you automate the refresh process, but it won’t bypass the 8 refreshes per day limit imposed by the Power BI Pro license. If you need more frequent refreshes, you might consider the workaround mentioned earlier or upgrading to Power BI Premium.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you very much for the detailed explantion.