Forum Discussion
bmcminn
Helper II
Helper IIValues show in transform but not in data
Hello. I'm new to Power BI. Thanks for your help. I have three tables in my model, all csv files. For one of the tables, the values don't appear in the data view. They do for the other two tables,...
Hi bmcminn
I saw the values in Power Query editor, what I mean is that all the rows in your original CSV were active so you loaded all 1,048,575 rows including those blank rows. So how many rows did you expect in your original file?
Hi bmcminn
I saw the values in Power Query editor, what I mean is that all the rows in your original CSV were active so you loaded all 1,048,575 rows including those blank rows. So how many rows did you expect in your original file?
bmcminnHelper II
Helper IIYou're totally correct Anonymous , that's exactly what it was. As soon as I removed all the blank rows (689,777 of them), the data view shows the fields filled.
I appreciate your help. 🙂