Forum

Power Query and Fol...
 
Notifications
Clear all

Power Query and Folder Permissions

3 Posts
2 Users
0 Reactions
50 Views
(@mitten222)
Posts: 10
Eminent Member
Topic starter
 

I have an access database and have connected power query into it to pull data into a some excel spreadsheets.  These spreadsheets are accessed and updated by users who do not currently have permission to the folder where the access database resides.  If I give users read only permission will they be able to refresh the queries, they currently cannot.  Any suggestions would be helpful. 

thank you

 
Posted : 28/06/2023 5:32 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Lisa,

Yes, they should be able to refresh the query.

Mynda

 
Posted : 28/06/2023 8:25 pm
(@mitten222)
Posts: 10
Eminent Member
Topic starter
 

Thank you so much! I will see about giving them read permissions to the folder.

 
Posted : 29/06/2023 10:30 am
Share: