Query that is not supported in DirectQuery Mode

[BoschRBEI]

I am getting the below error when I add a simple new custom column to a table in Edit query mode.

It is not that it is happening for all tables from the same database. but it is happening only for few tables.

In query edit mode

When I click on Apply changes I get the below message

when i click on Apply Changes

Request some one to help me in ths regard

[v-qiuyu-msft]

Hi @BoschRBEI, 

What's the formula did you use to create the custom column? 

There are some limitations when using DirectQuery mode, see: https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery#limitations-of-directquery

Best Regards,
Qiuyun Yu

[BoschRBEI]

Hi

I just created a custom column by copying the existing column. This is working fine with other table and not working with some tables. We can have a skype call and I can show you this.

Thanks for your support

Best Regards.

Girish