Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone
I created a new dataset yesterday and as source i used a folder. In this folder are csv files from every day back to 01/01/19.
Today i saw that i have [null] entries in a column, but if i use one of these files with null entries as single csv source i don't have this problem.
If there just would be 10 or 20 it would not be a problem but it affects more than 65% of 1.23M values.
I checked a Dataset which i created almoste a year ago, sam path and folder as source and i don't have this problem.
Tried it on two different machines with the same result.
I have the same pattern when i use power querry editor in excel.
Update: If i export the data again from the source system it shows the missing value, but this is not an option because there are 750 export files.
Perhaps someone has an idea why or how this is happen.
Regards
Robin
Solved! Go to Solution.
Hi @RobinH ,
if I understand you correctly, is the problem due to the source system?
You could compare the files before & after re-exporting with a tool like kdiff3.
http://kdiff3.sourceforge.net/
Hi @RobinH ,
if I understand you correctly, is the problem due to the source system?
You could compare the files before & after re-exporting with a tool like kdiff3.
http://kdiff3.sourceforge.net/
Hi @mwegener
Thank you, found out that there were some changes on the Source system so my exports had more colums for 3 weeks and then one less but with another name.
Regards
Robin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |