Getting error while connecting to share point online or One drive folder using organization account

[HimparIn123]

Getting error while connecting the powerbi online to sharepoint gives an error such as below even though i have completed access to the sharepoint folder even the office365 folder. I need to resolve this issue on priority , i have worked on this previously and i know it works perfectly. can you help resolving the connectivity issue. 

Error i am getting is 

The URL is not valid or you do not have permission to the site. Please check the URL and make sure you have permissions to the site

Do not have the URL handy? You can click Connect to see the content available to you at the root level.

This error is not proper since the URL is correct even though it is not connecting

The URL is not valid or you do not have permission to the site. Please check the URL and make sure you have permissions to the site

[v-shex-msft]

Hi @HimparIn123 ,

What connector you use to get data? Web connector for sharepoint/onedrive connector? Please share more detail information.

How to Get Your Question Answered Quickly
In addition you can also take a look at following links about use web connector and sharepoint connector to get online files:

Loading Excel Files from Sharepoint

Use OneDrive for Business links in Power BI Desktop

Regards,

Xiaoxin Sheng

[HimparIn123]

online version where i tried to connect the excel directly to the PowerBi and try to pull the report and show the data. 

---

@v-shex-msft wrote:

Hi @HimparIn123 ,

What connector you use to get data? Web connector for sharepoint/onedrive connector? Please share more detail information.

How to Get Your Question Answered Quickly
In addition you can also take a look at following links about use web connector and sharepoint connector to get online files:

Loading Excel Files from Sharepoint

Use OneDrive for Business links in Power BI Desktop

Regards,

Xiaoxin Sheng

---

[v-shex-msft]

HI @HimparIn123 ,

Maybe you can try to enable relative path option parameter to convert your url to 'root path' and 'relative path' to fix connectivity credentials issues.

let
	Source=Web.Contents("https://microsoft-my.sharepoint.com",[RelativePath=detail path])
in
	Source

Regards,

Xiaoxin Sheng