Import sharepoint list like excel

The sharepoint excel export function generates a .jqy file that I can use with excel, is there a way to use the same method for powerbi directly? I've been looking into OLE DB, which seems to be the way excel does it. There are so many different ways and the documentation on this is somewhat convoluted, perhaps someone here has already done this or know of a guide 🙂 

Sharepoint list queries become insanely slow on large/complex lists, I've been forced to export the sharepoint list to excel first and then import data to my report from the excel table. It is a really ugly workaround, but fetching 15k + rows from the same sharepoint list in the standard way takes several hours while the excel query takes 15-20 seconds to get the information i need. The primary problem with this workaround is that this is not going to work for scheduled dataset updates, because I still have to manually update an excel file.

In other words, what I want is to be able to make use of the sharepoint list views, so that I don't have to do that same work with powerquery again. I believe the reason for the standard sharepoint list query being slow is due to a need for expanding records or reference columns like user claims, lookup/choice etc.