880 MB CSV File

You can import a large CSV file via an ODBC driver. Here are the steps:

1) Assuming ODBC driver is installed in your PC make sure to add "Microsoft Access Text Driver" to User DSN

2) In Power BI

Get Data > Other > ODBC > Connect

3) DSN

Select CSVFile or whatever name you have given

4) Advanced Option - Connection String

dbq=d:\filepath\;extensions=asc,csv,tab,txt

5) Advanced Option - SQL Query

select * from filename.csv

Click OK

6) If asked for credentials 

Select "Default or Custom" and don't enter in any credential details unless necessary

Click Connect

Now data preview should come.

Click Load or Transform

Cheers!

Mark this as an answer in case this resolves the issue