Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Cannot convert value " of type Text to type Integer

I'm importing data into Power BI and I have "Duration" column which stores duration in seconds. I want to convert it to minutes so I've created a new column and used the following function: ROUNDUP ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, Anonymous 

    That must be mytable[Duration] is a text column, means there must be some text format value in it.

    Please change the data type of this column into number as below:

    Then you filter which row is error.

     

    Best Regards,

    Lin

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
7 years ago

You could use the column quality and distribution features under the View menu in Power Query to have a look at your data.  You should be able to find the dodgy values that way.