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 ,
  

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.

JuanFcoCalquin's avatar
JuanFcoCalquin
Frequent Visitor
2 months ago

Hi v-anbandari 

Yes, the suggested steps were helpful and led us to the solution.
Thank you for your support.


Juan Francisco Calquín M.