Forum Discussion

gbillerbeck's avatar
gbillerbeck
Copper Contributor
Oct 16, 2019

Power Query Request to external Sharepoint / Log-In fails

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

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    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)

Resources