why there is limit on number of Row (Max 100) to apply transformation
Nathan y commented
Workaround doesn’t work. System hangs if you highlight a range that’s more than 100 rows.
Kukjin Lee - MSFTResearch commented
Good question. Thanks. As a workaround, if we manually highlight the data range and click "Get Transformations", we can get 100+ rows results. We consider addressing 100 limit in a future update.