Power Query Request to external Sharepoint / Log-In fails

[gbillerbeck]

Hi,

I'm trying to make a Power Query to an external (client) Sharepoint. The URL identify the document and the connection is established... but no data is loaded. 

In then Navigator the table preview shows the header "Kind/Name/Children/Text" (?) and the Web Preview shows the Log-In dialog. I assume... the Log-In is the problem... but where to fill in the Log-In data for the query?

Thx

Goetz

[#2]

@gbillerbeck 

Working with Sharepoint you shall take site root URL in connection string, and after that select your element (file, list, etc depends on connector)