Forum Discussion

MBAKU's avatar
MBAKU
New Member
7 months ago
Solved

SQL Query working on Datamart but not on Fabric Warehouse

I have an SQL query in a powerbi dataflow that is working when it is connected to a datamart. I need to migrate it to a fabric warehouse but when I change the source to the fabric warehouse the previ...
data warehouse
warehouse
  • Thomaslleblanc's avatar
    Thomaslleblanc
    7 months ago

    What you’re seeing (“Evaluation Cancelled” in Dataflow Gen2 when you switch from Datamart to Fabric Warehouse) is usually a mix of:

    1. Power Query Online’s preview/evaluation time limit being hit (10‑minute evaluation window) and/or
    2. T‑SQL differences between Datamart and Warehouse that prevent the query from returning schema quickly enough to validate.
Thomaslleblanc's avatar
Thomaslleblanc
Icon for Super User rankSuper User
7 months ago

What you’re seeing (“Evaluation Cancelled” in Dataflow Gen2 when you switch from Datamart to Fabric Warehouse) is usually a mix of:

  1. Power Query Online’s preview/evaluation time limit being hit (10‑minute evaluation window) and/or
  2. T‑SQL differences between Datamart and Warehouse that prevent the query from returning schema quickly enough to validate.