![]() ![]() Open the ribbon Data and click on From Text/CSV in the left upper corner. What I suggest is the following: I import both CSV files into Power Query Editor in Excel, merge them by their keys and compare all corresponding columns.įirst, you have to import both files in Power Query in Excel. Let’s take a look at a Power Query solution. ![]() That all is a lot of work and the result is unreliable. You also have to sort both CSV files before you start comparing them. But they are designed to compare code lines and not to search for differences in huge CSV files. There are many tools which compare two files line by line like Notepad++, Visual Studio Code or many others. Earlier, I used Notepad++ or Visual Studio Code for comparing CSV files but nowadays I use Power Query for that! The first step is to uncover the differences. And it is your task to find out what the problem is and, of course, you have to fix it. But the tester does not describe the exact cause, they just export a CSV file from both systems and say that the numbers are not the same. Imagine the following scenario: You have migrated a report from an old system to the great Power BI and a tester reports a bug in the new report. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |