Forum Discussion
How to load csv file with more then 5 Gb size
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
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
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
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