Regarding Dataflow

Anonymous · ‎08-16-2023

Can We Transfer the data between two different gateways to different Databases?..Please let me know if it possible.

I tried, but While creating dataflow I unable to find 'Add Destination' Option in Power Query online in power bi service. Can you people help me Out of this.

This is what I want to try.

Thank you

ibarrau · ‎08-16-2023

Hi. What is it that you want to do with two gateways? I mean, I'm not getting it. You can install more than one gateway sure. You can have a dataset/dataflow using one and another dataset/dataflow using another one. But you can't move data like "gateway -> gateway -> dataset".

When you use Dataflow the data is stored in a black box as "Dataflow". The only way to get that data is using PowerBi Desktop. As an alternative you can connect an Azure Storage Account (data lake gen2) in order to let the dataflow store the data in there. You can't use other destination for a Dataflow.

I hope that make sense.

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

Happy to help!

LaDataWeb Blog