Sharepoint connection issues once published, but not locally

[Tagoad]

Our data model has a connection to a sharepoint workbook to allow our clients easy access to inputting manual data. Up until yesterday this was working fine, but now it says invalid credentials. This connection is anonymous and doesn't require a key or anything, and works just fine in the local environment still. This is the setup for the source = Excel.Workbook(Web.Contents(url), null, true). The url is actually the url that is used when you open the sharepoint file in app. Any advice on what might be going on is greatly appreciated.

[collinq]

Hi @Tagoad ,

I understand the error but where is the error occurring?  Is it in the Gateway?  Is it in the Service?  Is it in the Desktop file?  Is it in one or two or all three of those locations?  

As for the file and SharePoint - have new security items been placed on the folder where the file is located or is the file somehow "locked" by a user or password protected itself?

[Tagoad · Accepted solution]

Thanks for the reply, I actually was able to fix it by using the Sharepoint integration instead. Im not sure why we weren't using that to begin with, but that fixed the issue.