This Query Contains Transformations That Cannot Be Used in Directquery

Question

Invoking the following function in Power Query editor returns the error below:

let
    Origem = (x, y) => x * y
in
    Origem

Invoked Funtion:

This query contains transformations that cannot be used in DirectQuery.

This is the only query I have in this data model so I have no idea why this message..

Can anyone help?

Thanks!

Accepted Answer

This is a Power BI bug with the new Composite Model Preview setting.

If you turn it off, restart Power BI, then copy and paste the old query into a new one, and delete the old one, it should refresh fine.

Reference:

1 Answer