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!

Answer 1

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:

DirectQuery errors on imported tables. July 2018 Composite Models.

this query contains transformations that can't be used for directquery