Table content different in Query Editor and Table View

[SvenP]

Hi there,

I ran into a weird issue: I have created a datetime table in the Query Editor which shows the infor I want. But in the table view, the data is very different. See screenshots below (Query Editor result on the left, Table View on the right).

Thanks for your help.

Cheers, Sven

[amitchandak]

How you created the second column from first column

[SvenP · Accepted solution]

@amitchandak not sure I understand what you mean.

I have created the datetime calendar in the query editor. The other table was not created. It is simply how the datetime calendar appears in the table view.

However, I closed PBI and re-opened it and the issue disappeared.

[etohimself]

I experience a very similiar issue. PowerQuery and Table View are different from each other. Two different column headers seem to be switched for no obvious reason. 

[amitchandak]

😀