Home

PowerQuery Sharepoint Credentials?

pe29501
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

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies