Just this morning I made a mental note of Power BIs 1 million row limit in certain circumstances. I don't have any immediate plans to pull a million rows right now but I could see it happening. 65k would be easy to pull off, a year of some poorly formatted data blew through that recently.
(I did push 10 million rows but that was by accident, some Power Query code got a little greedy)
(I did push 10 million rows but that was by accident, some Power Query code got a little greedy)