Free user doing the on-demand refresh?

[Anonymous]

Hi,

I am using Powerapps and Power Automate to create a refresh button and attach it to the main page of Power BI report --to allow users to have an on-demand refresh. I'm developing the entire solution with a pro license, while my user is under a free license.

So if I'm going with PowerApps and Power Automate to refresh the dataset then is a Pro license required or not for the user?

[Hariharan_R · Accepted solution]

Hi,

I hope you will be using Power Automate to refresh the Power BI dataset. This is not based on user and it is based which Power BI account you used in Power Automate on Power BI dataset refresh action.

Thanks

Hari

[Anonymous]

Hi Hari, thanks for your reply. 

Another problem that I faced is this type of error when I want to schedule a refresh. 

{"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"Refresh is not supported for datasets with a calculated table or calculated column that depends on a table which references Analysis Services using DirectQuery."}}],"exceptionCulprit":1}}}

Do you know how can I disable Analysis Services from scheduled refresh?

[Hariharan_R]

Hi,

There is a similar error thread already open. Please refer this - https://community.powerbi.com/t5/Service/Refreshes-for-Datasets-containing-Calculated-Tables-over-Di...

Thanks

Hari