search

gsimardnet / PowerQueryNet

Run M Language (Power Query Formula Language) from anywhere.
MIT License
189 stars 32 forks source link

What could be the reason for different output for the same query on 2 different computers? #22

Closed amks1 closed 3 years ago

amks1 commented 3 years ago

I am running a query within an excel file. I run the query on one computer, and it gives me a wrong output. I copy the exact same file to another computer, run it, and it gives me the correct output.

I installed PowerQueryNet on both computers from the same installation files.

I'm stumped, what could be the reason for this?

gsimardnet commented 3 years ago

I never saw that kind of issue. Does your query have any other dependency or is it just reading an Excel file ? Since both computers have Excel, did you try to run the same Power Query using the "Get Data" feature from Excel ? What do they ouput ?

amks1 commented 3 years ago

The query has the following steps: image

The source is an excel file whereas the merged table is from a web API.

Yes I ran the queries within excel and it returns the correct results in both computers loaded into the excel sheet. But when Power Query Net runs, it outputs the wrong result (I'm using -o csv) on one computer.

The correct output is supposed to be a table with around 2500 rows. The wrong output shows the full initial table with about 5000 rows (I guess the filter in the last row doesn't get applied).

Both computers are running Windows 10, the only difference is in the version. The computer giving the wrong result has Windows 10 Workstation and the other one has Windows 10 Home. Apart from this, there's no other difference. Also: I have tried PowerQueryNet with other queries in other excel files, and they all work well. It's a head scratcher for sure.

gsimardnet commented 3 years ago

Then it could be related to issue #17.

amks1 commented 3 years ago

I don't understand how? There's no commas in these files.

gsimardnet commented 3 years ago

I think I misunderstood. Now I see that you use "-o csv" in both computers. So I guess the problem is elsewhere but to be sure, did you try a different ouput ?

Otherwise, I would look into the Regional Settings parameters and compare both computers. Go in "Control Panel\All Control Panel Items\Region" do you have the same format ? Then click the Administrative tab and "Change system locale..." button. Be sure that they have the same settings there too. You can also type chcp in the command prompt to see your current active code page.

amks1 commented 3 years ago

@gsimardnet Problem is now solved. Everything was the same in both computers except the "Regional Format". image

In the computer with the correct output it was "English (World)" whereas in the offending one it was "English (United States)". After changing it to "English (World)" the output is now as expected.

Although I don't have a clue how that could lead to such a huge disparity (especially when Excel displayed the correct output on both), I'm glad it's now fixed. Thanks for the help!