Forum Discussion
Getting error while connecting to share point online or One drive folder using organization account
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
3 Replies
- AnonymousNot applicable
Hi Anonymous ,
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
- AnonymousNot applicable
online version where i tried to connect the excel directly to the PowerBi and try to pull the report and show the data.
Anonymous wrote:Hi Anonymous ,
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
- AnonymousNot applicable
HI Anonymous ,
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 SourceRegards,
Xiaoxin Sheng