Forum Discussion

MBAKU's avatar
MBAKU
New Member
8 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
    8 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.
Anonymous's avatar
Anonymous
Not applicable
7 months ago

Hi MBAKU ,

 

Thank you Thomaslleblanc  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Best Regards,
Tejaswi.
Community Support

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 months ago

    Hi MBAKU ,

     

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

    Thank you.