Query result doesn't match returned data

[Anonymous]

Hi all,

First post here so please be gentle. 😉

I'm new to Power Query (Desktop) having previously only used it within Excel.

I have an SQL query source that returns the following data when viewed in the Power Query Editor:

yet in my report I get the following values for the Cabinet_DocID and Editor_ID:

I'm at a loss to explain what has happened to the values highlighted in red above. Why are they displaying as either 1 or two?

The only difference I can see in the source data between the columns that are correct/incorrect is that the values which were changed are numbers not text.

I feel like I am missing something stupid, but can't figure out what it is.

Any help greatly appreciated.

Thanks,

Alex.

[Anonymous]

A search of Stack Overflow yields the following possible answer: 

https://stackoverflow.com/questions/50321954/power-query-merged-query-returning-incorrect-result

But I haven't applied a sort or anything to either of the offending columns.

so now I'm even more confused.

😕

[Anonymous · Accepted solution]

Okay, so it seems the numbers appearing were as a result of the values being numerical.

My initial attempt at changing the format lead to frustration because I didn't realise that the report doesn't automatically update the format of any data displayed until you deselect and re-select all the columns.