Format Change in Power Query

[gusdahu]

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

[MFelix]

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