Forum Discussion
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, and in transform they appear for all three files. I think these images will do a better job than I can describe in words.
I'm using PBI Desktop Version: 2.107.841.0 64-bit (July 2022)
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?
4 Replies
Hi bmcminn
My guess is that you loaded all blank rows, the total rows of the "blank" table shown all rows were active in original CSV, you can use the Power Query editor to remove blank rows or make sure you don't have all blank rows active in your original file.
- bmcminn
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.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?
