Forum Discussion
Power Query and Power Bi loads do not match
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
3 Replies
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
Hi EugeEPL
This sounds strange, Is it possible to show this error with screenshots in Power QUery and Desktop?
Best regards
Michael
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!
