I'd just get a powerbi connector if i had the budget, thanks though

FWIW if you hit the 10k rows limit emailing csv then Tactical Connect's Sharepoint connector was well worth the cost for me for ease of getting Power BI running

Lately I am thinking about using the SS 2.0's ftp function to move search results to remote location, in this case Onedrive or Gdrive then using the output as the datasource for Tableau and Spotfire. Unfortunately I am too busy lately with more high priority projects. In principle it should work seamlessly.

Wont this hit the 10 mb limit for large results?