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 Learn

Regards,
Yugandhar.