Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
datasetleo
Helper I
Helper I

Excel Power Query - Data Source Settings - Sharepoint - Clearing permissions on file open

Hi, All!

I am testing pulling data from Sharepoint. Data is pulling correctly to power query.

I am using "organization account" settings, but they get stored once I close the file.

Is there a way to clear permissions once Excel file is closed so that once Excel file is open back up, user should sign in to sharepoint?

I managed to manually clear permissions with  data source settings, but I wonder if there is a way to ask for sharepoint sign in once file is open to ensure only people from organization have access to the data?

Thanks!

 

Snag_2e5b9d.png

1 ACCEPTED SOLUTION
Jimmy801
Community Champion
Community Champion

Hello @datasetleo 

 

I think this is a doubled post.. however ... 🙂

 

as far as I know, the credentials are not stored in the file, but on the profile of the computer. So, as soon you pass the file to another computer or the file is opened by another profile, the credentials are no longer there and have to enter the credentials as soon as a refresh is executed.


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

View solution in original post

3 REPLIES 3
Jimmy801
Community Champion
Community Champion

Hello @datasetleo 

 

I think this is a doubled post.. however ... 🙂

 

as far as I know, the credentials are not stored in the file, but on the profile of the computer. So, as soon you pass the file to another computer or the file is opened by another profile, the credentials are no longer there and have to enter the credentials as soon as a refresh is executed.


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

Makes pefect sense. But then when the file is opened by another user on another computer, why Excel automatically goes into anonymous mode and then fails query refresh instead of asking the user to choose how to sign in correctly? Any controls to change this?

this would be useful for me to know too.... I have mine connected to a D365 environment, and it doesnt automatically prompt the diferent user to enter their credentials when they try to reresh the data, just throws up access errors 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.