Forum Discussion

bmcminn's avatar
bmcminn
Icon for Helper II rankHelper II
4 years ago
Solved

Values 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,...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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?

bmcminn's avatar
bmcminn
Icon for Helper II rankHelper II
4 years ago

Hello.

I'm not sure, but I believe there are values in the file, they can be seen in the transform view. They are also available for calculations making new columns. And also for making relationships in the model view.

Thank you.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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?

  • bmcminn's avatar
    bmcminn
    Icon for Helper II rankHelper II
    4 years ago

    You'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. 🙂