Forum Discussion

RT6's avatar
RT6
Frequent Visitor
3 years ago

Related in Direct Query Mode

Hello!    I am trying to do basic calculation Related in the Direct Query mode:   Sales Amount = RELATED('product'[Unit_Price]) * sales_streaming[Units]       and i get the following er...
DAX
Direct Query
related
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi RT6 

This error is thrown when some aggregation (in this case the count) is been translated to M for execution, so it's not really SQL yet . You can check your query in Power Query Editor to see whether some queries affect your operation . 

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • RT6's avatar
    RT6
    Frequent Visitor
    3 years ago

    Hi Alisa!

     

    Thanks fro your answer.

    The issue is after any transformation in Power Query, like split columns, change data type etc i get the following error:

     

     

    I need to maintain Direct Query connection. I can aggregate two tables for example, but i cannot change data type even in PB Desktop, so i cannot perform any calculations.

     

    Any ideas? Thanks!