not able to connect sharepoint file with power bi

[Anonymous]

Hi Team,

I am trying to connect  excel placed at sharepoint location-->in folder-->Exchange Rate site-->HR Analytics folder

The link looks like:      https://xyz.sharepoint.com/:f:/s/POWERBITOBAMBOOINTEGRATION/EqOqE0jUZGZLrmF45MmkNhsBDCpG-ZS_1AaJzgN93oylQg?

using web connector.Also tried using Sharepoint Folder connector, but its giving error below:

Sometimes its ask me to sign in with organizational accout irrespective of that its giving error.

Can you please help me out to resove this.

Regards,

Arundhati

[lbendlin · Accepted solution]

The Sharepoint Folder connector will work but it requires you to specify the native site URL, without the :f:/s  part.

[lbendlin · Accepted solution]

The Sharepoint Folder connector will work but it requires you to specify the native site URL, without the :f:/s  part.

[Anonymous · Accepted solution]

with removing above i m now abe to connect.thank you very much