Copy-DbaDbTableData using integrated authentication and query as source - data is not getting copied

[vansree]

I am trying to copy-dbadbtabledata and it is not working using windows integrated authentication.
First it asks for both servers credentials, I thought it is a bug.

I gave same windows login credentials for both source and destination.

Later sometimes it gives an error as "[Copy-DbaDbTableData] You must pipe in a table or specify SqlInstance, Database and [View|Table]." sometimes it wont give error.
either way the data is not getting copied

Copy-DbaDbTableData -SqlInstance "SQL1\InstD" -Database "DB123_Dev"
-Query "SELECT * FROM DWDB.TableName WHERE YearSet = '2020' " -Destination "SQL2\InstQ" -DestinationDatabase = "DB123_QA" -DestinationTable = "DWDB.TableName" -Truncate

Note: I can do these commands without using credentials "Invoke-DbaQuery", "Write-DbaDbTableData" and works.

Also, the end goal is to transfer 10 Million rows of data. Is there a better way using dbatools? If not, will go to SSIS package.

Thanks