Forum Discussion
Query result doesn't match returned data
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.
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.
2 Replies
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.
😕
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.