There is a couple of ways how to connect to the SharePoint file with Power Query, but first of all, I recommend the connection through SharePoint Folder. It is more versatile and can be used successfully with different file formats – CSV, TXT, Excel, or JSON.