Forum Discussion
Power BI csv import creating blank data
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.
Saarek not aware of anything, just make sure the data type of the column is correct, if there is a data type let's the number and then value turns out text, might run into issues.
also does values has delimiters? Maybe add and then during import in power bi, put delimiter to make sure there is no extra comma in the value which is causing this.
finally, you can try to use power bi dataflow and see if it works there but I will first perform previous steps.
✨ 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.
Thank you for your advice. I think I have potentially found the column that is throwing Power BI off. But, I cannot see why.
The column is formatted as Character within R and is being imported as Text within Power BI, which would be correct.
One of the problem values seems to be "28.63". I cannot change this column to a type of number because some of the entries are not compatibile with that, example "17/10.5". What I don't understand is why 28.63, along with about 6 other variations, fall over when all of the other hundreds of similar looking combinations pull through just fine.