Forum Discussion

gusdahu's avatar
gusdahu
Helper IV
8 years ago

Format Change in Power Query

Power BI Community,

 

I receive an error when I upload data into Power BI Desktop. The error is realated to the data being in a number format as opposed to text. Within the Edit Query Tab, I changed the format to text. However, the error still exist. How do I go about correcting this error?

 

Regards,

Gus Dahu

Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi gusdahu,

     

    In the query editor if you click on the cell of the error you will see in the bottom what is the value that is giving the error.

     

    Be aware that you should not click the error text but the cell.

     

    Regards.

    MFelix