Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Has anyone encountered null values when uploading data in pbi. I've noticed missing values when building my report and found out that I am having errors due to null values, and when i check the source file it was complete no blanks or errors, after that I tried uploading one single csv file that has null values and it was complete. Does anyone have a solution for this?
https://drive.google.com/drive/folders/1k7KeQTkI-ZScgcr2m8_uZgL9E36D4Km-?usp=sharing
I've may have found the problem some headers are different making thus making some values null any work around this because I have multiple files and it would take time for me to manually cleanse those files.
But how different are they? Power BI uses the headers to group the data vertically.
Some headers have extra spaces like dc_code and store_code and some and some are entered as date_departure but it shoul be date_dispatch
The automatic combine and transform feature can't help you with that. It's for the basic of combining files. The trailing and preceding spaces can easily be removed with custom M but for departure and dispatch date, what if there are files with both columns?
I am assuming you used the automatic combine and transform feature. This feagture uses to QuoteStyle.None which may be the reason why you're missing some values. Use QuoteStyle.Csv instead
More on that: https://learn.microsoft.com/en-us/powerquery-m/quotestyle-type
Otherwise, please identify which records have missing values.
I found out that some of headers have extra spaces or different from the usual headers do you think that causes the problem. Do you know any workaround cause I'm not really good at this.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
69 | |
68 | |
40 | |
29 | |
26 |
User | Count |
---|---|
89 | |
49 | |
44 | |
38 | |
37 |