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
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies