Forum Discussion

salmaGhezal's avatar
salmaGhezal
New Member
5 years ago

Transformation Alert on DirectQuery " DATAFLOW "

Hello,

 

When I select import option for DATAFLOW DATA , it takes forever to load the data. If I select Direct Query, I have been an alert as "This query contains transformations that can't be used for DirectQuery". Please provide your solution. 

  • Note  : I activate "Enhanced Compute Engine settings"

Any idea what the problem is?

 

Thanks

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    salmaGhezal , complex transformation is not allowed in direct query mode. As Data flow is the transformation layer, I think direct query mode applies to that do.

     

    Have you done any transformation in dataflow?

     

    • salmaGhezal's avatar
      salmaGhezal
      New Member
      5 years ago

      amitchandak , hello

      juste  add customs and Merging tow tables

      NOTE : I create a dataflow with only one entity and no transformation, but the same error is displayed