Forum Discussion
Problems in transforming data from a column
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
Thanks a lot. I've made those changes to the query I call from power BI and it seems to work.
Greetings
2 Replies
- amitchandakSuper User
Syndicate_Admin , Seem like you are trying that is direct query. Complex calculations are not supported in Direct Query
- Syndicate_AdminAdministrator
Thanks a lot. I've made those changes to the query I call from power BI and it seems to work.
Greetings