This query contains transformations that cannot be used in DirectQuery

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!

1 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: