Forum Discussion
Transform Data mode only show 100 rows
I was facing the same issue where I needed more than 100 rows from the example column. I followed the below steps and it seems to work for me.
1. Select and filter the rows from the example column(s) which would capture the required data variations.
2. Add the new custom column from examples and populate it until Power BI gets the logic right.
3. In the Applied Steps section, delete the filtering you have done in the first step and check if your custom column now has all the variations you wanted.
When deleting, it warns you that subsequent steps might get affected. But my custom column was the only next step and it turned out to be exactly what I wanted.
Hope this helps. Please let me know if you found more elegant way of doing this.
Thanks!
- Viking2043 years agoNew Member
This worked for me, thanks for the tip!