Forum Discussion
Null Values when Get Data from Folder
Hello,
I'm extremely new to Power BI so I apologize if this is a silly questions. I am trying to Get Data from folder. My folder contains two csv files. They have the same number of columns and information. Each of the files does have a row that was added after download but having checked every way possible for some sort of difference I cannot find one between the files.
When I run my query it only pulls the last column values from the file that is selected as the Example File. For the other file it is only pulling null values. Sorry I have not attached the files here as they contain confidential information, but any ideas or suggestions on what I'm doing wrong would be greatly appreciated.
Thanks!
Hi sbendorf1787,
Above description is too general. Could you please provide more detailed information about each step you applied?
Besides, here are some examples about load multiple .csv files from folder for your reference:
Loading and Combining Multiple CSV Files in Power BI
Import all CSV files from a folder with their filenames in Power BI
Best regards,
Yuliana Gu
2 Replies
Hi sbendorf1787,
Above description is too general. Could you please provide more detailed information about each step you applied?
Besides, here are some examples about load multiple .csv files from folder for your reference:
Loading and Combining Multiple CSV Files in Power BI
Import all CSV files from a folder with their filenames in Power BI
Best regards,
Yuliana Gu
Thank you v-yulgu-msft!
I apologize for how generic my post was. After posting I tried to recreate the issue with dummy data but did not run into the same issue. I then deleted the original files and got new csv. files and it seemed to do the trick.
Thank you so much for the reference files and I will make sure posts in the future include more detail : )
Sara B
