[Expression.Error] We cannot convert the value 0 to type Text.

[Marion]

Hi

I am trying to import Excel files that display a number format ".00" in several columns.

I need to convert figures to format "0,00" in my PowerBI file so I can aggregate them.

I replaced "." with "," in each column and chose currency format.

The following error message persists :

[Expression.Error] We cannot convert the value 0 to type Text.

Thanks for your help

[selimovd]

Hey @Marion ,

can you make sure that there is no transformation in one of the first steps?

Can you post a sample or example of your transformation?

Best regards

Denis

[Marion · Accepted solution]

Hi Selimovd,

I found the error. I was trying to change the format in a reference table, instead of changing the format in the source table... Thanks !