Forum Discussion
Refresh Dataset on Demand
Hello,
As I am still trying to understand the differences in the licences on the Power BI I would like to ask a question.
At the moment I am using the premium per user licence which allows me to refresh my dataset up to 48 times per day on schedule refresh or on demand though the service.
What I need to understand is the following:
I have placed a button within my report which when a user "hit" it, it will trigger the flow as to refresh the dataset. When a user uses the specific button, is the refresh using my user limit or i using the limit of the user that tiggered the flow from the report?
I hope it make sense
Thanks
Hi Kostas ,
>>if a user has a Pro licence, will the refresh button in the report (activated though Flow) will reduce the daily limit of the user published the report or of the user that triggered the action?
Yes, if the report is in shared capacity, the refresh from MS flow is also include in 8 times refresh limitation.
>>Also, is the unlimited in the premium capacity per user or only in the organisation?
As long as the report is in premium capacity, there is no refresh limitation both for user in or out organization.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi Kostas ,
If the button activated through Flow it will reduce the refresh slot. If you refresh by button on the power bi service itself, there is no limitation.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
8 Replies
There is no limit on refreshes in PPU/PPC when you trigger them manually , from XMLA Endpoint using script, or From Power Automate or via Rest API. The 48 limit is only on Scheduled refreshes in Service.
This is strange! As per the post it should be unlimited for the flows. For XMLA I Have verified myself but the Flow one should work too based on this :
https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
Thanks!
do unlimited refreshes also apply for pro license users?
Hi Kostas ,
>>if a user has a Pro licence, will the refresh button in the report (activated though Flow) will reduce the daily limit of the user published the report or of the user that triggered the action?
Yes, if the report is in shared capacity, the refresh from MS flow is also include in 8 times refresh limitation.
>>Also, is the unlimited in the premium capacity per user or only in the organisation?
As long as the report is in premium capacity, there is no refresh limitation both for user in or out organization.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hello v-deddai1-msft
Thanks for the answer above, just a clarification:
"Yes, if the report is in shared capacity, the refresh from MS flow is also include in 8 times refresh limitation."
Will the refresh slot reduced from the capacity of the user that uses the button in the report or from the user that published the report?
Thanks
Hi Kostas ,
If the button activated through Flow it will reduce the refresh slot. If you refresh by button on the power bi service itself, there is no limitation.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
