Forum Discussion

Saarek's avatar
Saarek
Icon for Helper III rankHelper 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.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

Saarek very hard to say but ultimately it is your data file that is causing the issues. Good luck!

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.