Forum Discussion
Access SharePoint Site with Different Credentials
When you specify the credentials for the SharePoint site, you can enter any OAuth credentials and you can specify whether or not it is for the specific site or essentially all sites in the root path.
Greg_Deckler Thanks for your reply. I noticed that when accessing the SharePoint site through Power BI desktop, I get the option to sign in with different credentials. However, I am still not able to connect for some reason. I have included two screenshots. One shows the error I get when trying to access the SharePoint site online. The other shows the error I get when I use my different credentials in the desktop application. I know those credentials work because I have accessed this SharePoint site as a mapped network drive. The SharePoint is 2007 if that has to do with anything?12
mathysbt, I just saw Anonymous's reply in my notification feed to this thread and reread it. I seem to have missed a key element. Yes, the site being SharePoint 2007 probably has everything to do with it. 2007 only supported WCF, not OData, OData was introduced in 2010. I would be highly surprised if you could connect to a SharePoint 2007 list using Power BI. I'd try it, but I don't have an environment to test with. I upgraded them all! :(
Greg_Deckler Anonymous That makes sense. I'll just have to wait until we upgrade haha. Thanks for your help!
Sean Yes i have and i still get the same error as the one i posted above. I don't have a SharePoint site tied to my account because our company doesn't have office 365. I just used my work email to sign up for a free Power BI account. This is why i need to enter different credentials to connect to the SharePoint site.
I would probably ask Anonymous he may know something about this - access sharepoint with different credentials.
