Allow Others to Refresh PBI Dataset online

[QC]

I have a PBI report/dataset publisedh to a team workspace, the dataset is 100% cloud-based, so it doesn't require gateway. I am the "owner" of said workspace on PRO license.

My question is: what I need to do to allow other users to (manually) refresh the dataset directly from PBI online (assuming they already have PRO license)? Do I have to add them as "contributor" to workspace? Or there is another way which permission can be limited to a single dataset? 

Thanks,

[QC]

Thanks! Automate counts refresh limit right? 

[edhans]

Yes. If you are in a Pro workspace, then pressing that button counts as one of your 8 in the 24hr cycle.

Please mark my response as the solution so others can see it. 

[edhans · Accepted solution]

Don't give them access to the workspace at all.

1. Create a Power Automate Flow visual.
2. From that, create a Power Automate flow that when a button is pressed, it will refresh that dataset.
3. Share that flow with the group that has access to the report with RUN AS priv's.

They can then refresh the report by pressing a button on the report. You can even add additional steps to the flow like notifying them the refresh has started via Teams or an email.

That way they have no access to all of the datasets, and anyone that is a Contirbutor or higher will bypass any RLS settings, so it is a bad idean in general.