How to load csv file with more then 5 Gb size

[maximchepak]

Hi, 

I have more then 10 files with inforation(size of on 700+/- Mb), if i'll try to connect them in 1 sheet, i see message about low memory in desktop and online version. If ill try to connect more then 2 of them in one sheet I have same error. 

I'll try connect 3 sheets with 3 different files, same error. 

If i'll load all my information in MS SQL base in one table its loadin in to power BI? or I need another product?

Than you. 

Regards, Maksym.

[v-yuezhe-msft]

@maximchepak,

Could you please post the full error message in Power BI Desktop when you loading CSV files? If you are a Power BI free or pro user, when you publish a PBIX file over 1GB to Power BI Service, you will get a file size limit message, but there is no limit about file size in Power BI Desktop, you should be able to load data from CSV files to Power BI Desktop.

In addition, you can load data from CSV files to SQL Server table, and you can use DirectQuery mode to connect to the SQL Server source in Power BI Desktop when you have large amount data in the table.

Regards,
Lydia

[maximchepak]

Error:

"There's not enough memory to complete this operation. Please try again later when there may be more memory available.
URI кластера: WABI-WEST-EUROPE-redirect.analysis.windows.net
Ідентифікатор дії: a55c9044-67d4-8784-fac9-7ebf77cb642e
Ідентифікатор запиту: 33c3b35c-f1f8-7c8f-89a1-cefabd4b8c68
Час: 2017-09-20 14:54:44Z"

Use Power BI 64x

[v-yuezhe-msft · Accepted solution]

@maximchepak,

It seems that the above error message come from Power BI Service, Power BI Service have 1GB file limitation. 

In your scenario, please load data to SQL Server and use DirectQuery in Power BI Desktop to connect to  the SQL data source.

Regards,
Lydia