Microsoft power BI can handle that much rows, in the editor you have the to keep TOP N rows.
Please find the image attached.Screenshot_2020-01-29 Only load 100 rows in load mode.jpg