Problems connecting to sharepoint folder

Question

Hi,&nbsp;I'm currently having problems connecting to a sharepoint site using the&nbsp;Sharepoint.Contents command and ApiVersion 14.PowerBI doesn't return any folders or files to connect to, although there are folders in the site and files in these folders.The query window is simply empty.&nbsp;Can anyone help me with this?&nbsp;Best regards,Martin&nbsp;

mattallington · Answer

You need to connect to the root site first. Something likemydomain.SharePoint.com/sites/mysite/

anonymous · Answer

Hi Matt,&nbsp;I already connected to the root-site in the code, but it only returns an empty table.&nbsp;Could the problem perhaps be due to missing credentials in sharepoint?&nbsp;Br,Martin

mattallington · Answer

I doubt it. If the credentials are wrong, you probably would get an error. But do you have access to the doc library with your credentials?

anonymous · Answer

Yes, when I access via a browser, I can see and access the necessary folders and files

mattallington · Answer

It's hard to say given you have blacked out the URL in the image. You could try clearing the credentials in Power Query. If they are right and the URL is right, I can't see any reason why it won't work.&nbsp;

Forum Discussion

Problems connecting to sharepoint folder

6 Replies

Related content

OData Error When Connecting to SharePoint Online

Dataflow - SharePoint Connection Problem

Sharepoint Connection

Sharepoint List Importing Problems

Connecting to sharepoint