The special vote count has seen Te Pāti Māori claim victory in six of the seven Māori electorates, ousting incumbent Labour MPs Kelvin Davis and Peeni Henare.
Te Pāti Māori candidate Takutai Tarsh Kemp has won Tāmaki Makaurau by a slim margin of just four votes over Peeni Henare.
In Te Tai Tokerau Mariameno Kapa-Kingi of Te Pāti Māori won with a majority of 517 votes over Kelvin Davis.
Te Pāti Māori now has six seats in Parliament, which creating an overhang of two.
The Port Waikato by-election will see the addition of another seat, bringing the total number of seats in the house to 123.
Preliminary results following election night had both Peeni Henare and Kelvin Davis ahead of their respective Te Pāti Māori candidates by almost 500 votes.
But despite losing the electorate, Henare looks set to return to Parliament as number 11 on the Labour Party list.
Davis is number two on the party list, but said he would not return to Parliament if he lost in Te Tai Tokerau.
Labour has been dealt some harsh blows in this year's election, falling well short of the numbers needed to form a government.
Nanaia Mahuta lost Hauraki Waikato to Hana-Rawhiti Maipi-Clarke of Te Pāti Māori, making Maipi-Clarke the youngest elected MP since 1853.
The victory for Te Pāti Māori marked the beginning of a political career for Maipi-Clarke, 21, and the end for Nanaia Mahuta, 53, after serving 27 years in Parliament.
Rino Tirikatene also lost Te Tai Tonga to Te Pāti Māori candidate Tākuta Ferris with a preliminary margin of 1463.
Co-leaders Rawiri Waititi and Debbie Ngarewa-Packer maintained convincing leads in the Waiariki and Te Tai Hauauru seats on election night.
Waititi was ahead of his closest competitor by 11,000 votes while Ngarewa-Packer maintained a lead of 6000.
The Labour Party still holds one Māori electorate after Cushla Tangaere-Manuel took the seat from incumbent Meka Whaitiri, who defected from Labour earlier this year to stand for Te Pāti Māori.
The electorates swung massively between 2020 and 2023.
RNZ.