Forum Discussion
gbillerbeck
Oct 16, 2019Copper Contributor
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
- SergeiBaklanDiamond Contributor
Working with Sharepoint you shall take site root URL in connection string, and after that select your element (file, list, etc depends on connector)