Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
today when i try to connect data from Sharepoint i receive this error:
"Connection failed, access denied"
Why?
Thanks
Solved! Go to Solution.
Hi @Anonymous ,
Which connector did you use? The web connector or the sp connectors as the pic?
I made a test here using the web one. Everything worked well. Here the verification method is organization account and the using the link as the picture : https://xxxxx.sharepoint.com
Regards,
Frank
Hi @Anonymous ,
Which connector did you use? The web connector or the sp connectors as the pic?
I made a test here using the web one. Everything worked well. Here the verification method is organization account and the using the link as the picture : https://xxxxx.sharepoint.com
Regards,
Frank
Hi,
i used Sharepoint folder, now it works,
What's the difference between connecor?
Hi @Anonymous ,
The difference is from the Sharepoint side. You can refer to the blog Folder vs. Library in SharePoint. Since the issue is solved, could you please makr the answer as a solution to close the case. Thanks in advance.
Regards,
Frank
Hello. This issue has gotten in the way of my Power BI work for years.
When I attempt the web connector, I receive the error above.
I look at one colleage's work, he uses
= Excel.Workbook(Web.Contents
and it works without issue. I try the same thing, I get that error. Ugh!
Sometimes, I can work around it by opening the SharePoint in Internet Explorer, then launching in Folder model.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |