Forum Discussion

JuanFcoCalquin's avatar
JuanFcoCalquin
Frequent Visitor
2 months ago
Solved

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

Dataflow Gen2 fails in Power Query editor when evaluating Fabric.Warehouse() navigation query. The issue occurs before refresh execution, while editing/evaluating standard M steps. It also occurs wi...
Dataflow
Need Help
  • v-anbandari's avatar
    v-anbandari
    2 months ago

    Hi JuanFcoCalquin ,

    Thank you for the detailed update.

    Based on your findings, the issue appears to be specific to the Dataflow Gen2 scenario using a gateway-based connection, as the gateway and Fabric Warehouse both work correctly in other scenarios.

    Please consider the following points:

    • Create a new Dataflow Gen2 instead of reusing the existing one.

    • Test the same configuration in a new workspace.

    • Recreate the gateway connection and reselect it during Dataflow configuration.

    • Remove and re-add the Warehouse destination to refresh the destination metadata.

    Thank you for sharing these findings. They help narrow down the scope of the issue and may be useful to others experiencing similar behavior.

v-anbandari's avatar
v-anbandari
Community Support
2 months ago

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:

Thank you.