Forum Discussion
Gen1 Dataflow with connection to upstream dataflow
Hi JessieF ,
Thanks for pointing that out. You’re correct, the way mixed connections operate in Gen1 Dataflows can be quite unintuitive.
1. You need to authenticate each data source, even when referencing another dataflow, such as linked or computed entities.
2. For on premises sources like SQL Server or network folders, you must use the on premises data gateway, which can be local or Azure hosted.
3. With cloud sources, Gen1 only allows personal cloud connections or the gateway.
4. Gen1 doesn’t support managed or shareable cloud connections, which is why you received the warning. These are available only in Gen2 Dataflows.
I hope this helps clarify things.
Helpful Refrence:
Install an on-premises data gateway | Microsoft Learn
On-premises data gateway - Power BI | Microsoft LearnRegards,
Yugandhar.
It needs to go thru an on-premises gateway. That could be setup in Azure as an Azure VM
Perhaps I wasn't quite clear. My question is actually about the interaction of mixed connections with Gen 1 dataflows. Could you perhaps expand on your answer to provide some articles to help me understand the suggestion.
thanks 😁
Hi JessieF ,
Thanks for pointing that out. You’re correct, the way mixed connections operate in Gen1 Dataflows can be quite unintuitive.
1. You need to authenticate each data source, even when referencing another dataflow, such as linked or computed entities.
2. For on premises sources like SQL Server or network folders, you must use the on premises data gateway, which can be local or Azure hosted.
3. With cloud sources, Gen1 only allows personal cloud connections or the gateway.
4. Gen1 doesn’t support managed or shareable cloud connections, which is why you received the warning. These are available only in Gen2 Dataflows.
I hope this helps clarify things.
Helpful Refrence:
Install an on-premises data gateway | Microsoft Learn
On-premises data gateway - Power BI | Microsoft LearnRegards,
Yugandhar.