Formatting a number as text

[Anonymous]

Hi!

One of my data sets has a column of data that is created by a formula in the Excel spreadsheet the data set is sourced from. Some items in the column are numbers like "2413" while others are a combination of numbers, spaces and letters "3425 DEL".

When I load this data set into Power BI I get an error. In the Query Editor, all items in this column that contain letters are shown as 'error'.

I think that this is a problem with the format of either the source Excel spreadsheet or of the columns in Power BI but I haven't been able to figure out the solution.

Does anybody have any ideas on how to get Power BI to load these items?

Thanks!

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may check steps in The Advanced Editor.

[Anonymous]

Hi Everyone,

I'm still stuck with this problem. Has anybody had this problem before?

Thanks!