Jan 30 2019
08:45 AM
- last edited on
Jul 12 2019
11:19 AM
by
TechCommunityAP
Jan 30 2019
08:45 AM
- last edited on
Jul 12 2019
11:19 AM
by
TechCommunityAP
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?
Jan 30 2019 09:20 AM
Do they have access to SPO site and do you use organizational account?