Power Query and Power Bi loads do not match

[EugeEPL]

Hello,

I looked at the forum and couldn't find a response, so here goes:

On first time load of a txt file, the first screen (power query) before clicking on 'load' shows me the data correctly, as follows:

Date	Debit	Credit
01/01/22	12	0
01/01/22	0	123
01/01/22	0	55
02/01/22	45	0

Once I click on load, in the models it shifts all the numbers on the credit column to debit, leaving the credit column with only 0s:

Date	Debit	Credit
01/01/22	12	0
01/01/22	123	0
01/01/22	55	0
02/01/22	45	0

How can I fix that? Is it due to the type of encoding of the txt file?

Thank you

[EugeEPL]

@Mikelytics thank you for your answer.

I feel really dumb! When taking screenshots to show you the issue, I found the problem. The data was not being shifted when loading, it was being sorted in a way that all the debits showed first (chronologically) and then all the credits, as opposed to just having a chronological table (based on column A) as in power query / excel.

Earlier, I had scrolled down to see if there were any debits and I only saw only 0, so I assumed they were shifted, but I needed to scroll down 5000 rows before seeing them.

SO sorry for wasting your time, it was only a sorting issue!

[Mikelytics]

Hi @EugeEPL 

This sounds strange, Is it possible to show this error with screenshots in Power QUery and Desktop?

Best regards

Michael

[EugeEPL]

Edit: I tried opening the file with excel and not problem there, no replacement of 0 in the debit colum with data from the credit column. I also tried to load the same txt file in a csv and again no issue in excel directly or through power query, but data gets shifted when loading to power bi.

What am I doing wrong? Please help