PowerQuery Sharepoint Credentials?

Highlighted
Occasional Visitor

I'm having an issue with an excel report that is using PowerQuery to pull data from Sharepoint Online.

 

I'm able to successfully edit the data source to accept my credentials and pull in data.

 

When i distributed the report to users (just copying the file); they get a HTTP Unauthorized exception. 

 

I've tried deleting the credential from Data Source Settings>Sharepoint.com>Clear Permissions; but they still get a unauthorized instead of a request for credentials.

 

I'm stumped as to where the connection is actually stored? (Hoping i can just delete the connection) Why can't i clear these out?

1 Reply
Highlighted

Do they have access to SPO site and do you use organizational account?