Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

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

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator

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

      Greetings