Problems in transforming data from a column

[Syndicate_Admin]

Hello

In my dataset uploaded to BigQuery and connected to power BI using Direct Query I have been trying to modify a column called "Vertical" that has values ENERGY and ENERGY, among others. I have replaced all the values in which ENERGY appears with ENERGY with the following formula:

= Table.ReplaceValue(#"Renamed Columns2","ENERGY","ENERGY",Replacer.ReplaceText,{"Vertical"})

When I close and apply the change, the following error appears in the graphs:

"OLE DB or ODBC error: [Expression.Error] Could not bend the expression to the data source. Try it with a simpler expression."

I wanted to know if you can think of any way to fix it.

Greetings

[amitchandak]

@Syndicate_Admin , Seem like you are trying that is direct query. Complex calculations are not supported in Direct Query

[Syndicate_Admin · Accepted solution]

Thanks a lot. I've made those changes to the query I call from power BI and it seems to work.

Greetings