Forum Discussion

Saarek's avatar
Saarek
Helper III
4 years ago
Solved

Power BI csv import creating blank data

I have a dataset that is created within R and then exported out as a single CSV file for Power BI to ingest.   This data set is 36 columns wide with, approximately, 6 Million Rows. Every row/column...
Need Help
  • Saarek's avatar
    Saarek
    4 years ago

    Yes, no matter what I did I could not get it to work via CSV import. In the end I created a basic R Script to import an RDS file (R Native file format) and it loaded fine.

    Obviously something wrong with the CSV import process in Power BI for this file, but I just couldn't find the issue and squash it.

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, Saarek 

PowerBI seems to have a limit on the size of Imported/Exported csv files.

You can refer to the solution mentioned by Anonymous in this post, use VBA code or other online tool to split the imported CSV file into different worksheets, and then import the CSV file into Power BI.

 

Best Regards,
Community Support Team _ Eason

Saarek's avatar
Saarek
Helper III
4 years ago

Yes, no matter what I did I could not get it to work via CSV import. In the end I created a basic R Script to import an RDS file (R Native file format) and it loaded fine.

Obviously something wrong with the CSV import process in Power BI for this file, but I just couldn't find the issue and squash it.