The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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.
Happy to help!