Starting with data flow and security issue

[Anonymous]

Hello,

We are at the first steps of using Data flow and the question of security arise.

If I want to create a data flow using a table from our Data warehouse (source1) , an Excel file from Azure Devops (source 2) and a certified data set from EDW (source 3). How do we manage the authorization for those three data sources?

Then imagine that this data flow is stored in EDW2,  how is working the security for this data flow?

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

For on-premise data sources, we need to add each of them into gateways. So you could manage the authorizations in the gateway. Here is the document about how to manage data sources in gateway.

There are a few known limitations to using Enterprise Gateways and dataflows, please see :

• Each dataflow may use only one gateway. As such, all queries should be configured using the same gateway.
• Changing the gateway impact the entire dataflow.
• If several gateways are needed, the best practice is to build several dataflows (one for each gateway) and use the compute or entity reference capabilities to unify the data.
• Dataflows are only supported using enterprise gateways. Personal gateways will not be available for selection in the drop down lists and settings screens.

Best Regards,

Xue Ding

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