Dataflow restrict access/use for power user

[tomas12344]

HI All

A customer hesitate to allow to use dataflow for Power Bi, becuase when this is allowed, all the users of the tenant can use this feature. And the administator is afraid that the users will do some mess, when duplicating data, DWH,... Currently in the tenant setting, there is not any limitation, to restrict this feature, like for other features of PBI to be allove to use only by some group of people.

The question is, what is the best practice to limit the usage of dataflow for power users of PBI. Is there any other posibilit how to restrict this?

thank you.

[v-henryk-mstf]

Hi @tomas12344 ,

Whether the advice given by @ibarrau  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Also, you can read below document for more details.

Understanding and optimizing dataflows refresh - Power BI | Microsoft Learn

Looking forward to your feedback.

Best Regards,
Henry

[ibarrau · Accepted solution]

Hi. The only option of dataflows as tenant level is to prevent them for all organization. Sadly that's the only configuration for now.

The only way to prevent users creating dataflows would be removing the PRO licence, but that might be a problem if you don't have premium or if all your users are pbi developers.

Regarding good practices there are many nice articles from microsoft about that: https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-best-practices

You can start right there

I hope that helps,