Forum Discussion
Issues connecting to sharepoint - Power BI and Excel
When you entered the credentials, did you have the option to pick what level of SharePoint these credentials were being applied to? A common thing i've noticed is something the UI tries to apply the credentials to the base level of SharePoint, rather down at the site level. Naturally you are going to have security access to your site, but unlikely to have the correct access for the full SharePoint.
The box i'm talking about will be at the bottom, as a drop down. When you select it you'll see options like:
Try selecting the right level in here and see if that works
Anonymous
I entered the credentials as prompted but it didn't ask for any privacy levels. This is a an organisational sharepoint site and I used my work login. I did check the privacy levels as well
And yes, I did check all the possible privacy levels that were listed. My issue is, when I try the same steps from the query editor in Power BI, it work perfectly. I haven't had issues connecting to my company's sharepoint site in the past
So when you signed in, did you do so from "Organisational Account"? Did it look like this screen?
The drop down i'm refrerring to is the one labeled "Select which level to apply these settings to"
Yes, thats what I did. And I tried all the different levels and still nothing. Could it be something to do with access restrictions to the site? If so, it works when I try it in Power BI