Permission to access company sharepoint site

[akhaliq7]

Problem

I have previous experience connecting to my company's sharepoint site in Power Query however I cannot connect to a subsite that is created by the Marketing team,

Attempts

• When I type in the url: company.sharepoint.com then an option shows the marketing folder but when I click it then only a single item called forms shows.
• I have also entered the url: company.sharepoint.com/sites/***SharePoint but even this after I entered my username and password returned with the message: "We could not authenticate with the credentials provided. Please try again."

[ChielFaber · Accepted solution]

I'm not a sharepoint expert but I reckon that's the issue creating your problem. When your colleagues add you to the sharepoint site as a user you should be able to load the data.

[akhaliq7]

Not using dataflows just importing the data in power query using the SharePoint.Contents connector

[ChielFaber]

Seems to be a problem with the acces rights to the sharepoint site. Do you have acces to the sharepoint site itself (did your colleagues add you as a user to the site?).

Also if your accessing the sharepoint site through dataflows it must be added to the gateway.

[akhaliq7]

I have access to the company's sharepoint site but I do not have access to the marketing departments sharepoint site which is like a subsite within the company site.