Best Practice for Exporting Large Data Tables?

Hey all,

I have a table I created that produces 3.6M records that I need to export, I've been trying all day but PBI is randomly dropping data and for the life of me I cannot determine why. I've even tried reducing my date filters to small ranges and still, PBI drops data when copy/pasting.

For example, I have the raw table here listed one order where I am trying to figure out why I'm losing data.
Correct data:

Then this is after the export
Bad Data:

I've changed my ranges from two months, to one, to weeks...data drops. I thought maybe it's something with this order, but it's others too. Well that and the first image cleary shows it in the raw data before export.

Is there a way I can query/filter this [non PowerQuery generated] table from Excel? Or Access? MSSQL? I also downloaded DaxStudio but am trying to figure out how to simply filter a table for export rather than create dax queries. 

Any help is very much needed, if I wasn't already fairly bald I'd be pulling out hairs by now.
Thanks fella datanaughts

DU