"Keyword not supported: variables" error using Dataflow gen2 when evaluating Fabric.Warehouse()

Hi JuanFcoCalquin,
Thank you for reaching out to the Microsoft Fabric Community.

Based on the error details shared, the failure is occurring while Dataflow Gen2 is evaluating the Fabric.Warehouse() navigation query. Since the same behavior can be reproduced with a simple Enter Data → Fabric Warehouse scenario,the issue does not appear to be related to the query transformations.

As a troubleshooting step, you can try the following points:

• Recreate the Fabric Warehouse connection and verify that the connection is configured correctly.
• Remove and re-add the Warehouse destination in Dataflow Gen2 to refresh the destination metadata.
• Review the Microsoft documentation to ensure the Warehouse connection and destination settings are configured according to the documented requirements.

Relevant Microsoft documentation:

• https://learn.microsoft.com/fabric/data-factory/connector-data-warehouse
• https://learn.microsoft.com/fabric/data-factory/dataflow-gen2-data-destinations-and-managed-settings

Thank you.

Hi v-anbandari , thanks for your reply

We think it's a problem with the data gateway, because we have now confirmed the following:

1. The on-premises gateway works correctly outside Dataflow Gen2:
A Power BI semantic model connected directly to SQL Server refreshes successfully through the same gateway.

2. Fabric Warehouse works correctly outside the gateway path:
A clean Dataflow Gen2 using Enter Data and a cloud connection writes successfully to the Warehouse.

3. The failure is triggered specifically when Dataflow Gen2 attempts to use a gateway-based connection in the Warehouse/Dataflow path.

4. After this gateway-based attempt, the Dataflow/connection metadata appears to remain in a corrupted state:
even when switching back to a non-gateway/cloud connection, the same error persists.

This strongly suggests a Dataflow Gen2 / Fabric Warehouse / Gateway binding metadata issue, where an unsupported “variables” keyword is being persisted or passed to the gateway connection string parser.

I hope this extra information helps you help us with the problem

Hi JuanFcoCalquin ,
  

Could you please confirm if your issue has been resolved using the suggested approach? This will help other community members facing similar scenarios.
 

Thank you for being part of the Microsoft Fabric Community.