Forum Discussion
Solved
(Solved) Power Query credentials with data from SharePoint
Hi Everyone, I have an Excel file in A SharePoint folder meant as a template for users that can download it to run specific tasks. To validate the template drop-down lists, the file gets data fr...
You don't need to call entire SharePoint site to filter and access single file. Instead you may use From Web connector. Open file in desktop app, File->copy path at the top. Remove ?web=1 at the end of URL and use it in From Web connector.
With that you may give user R/O rights on Template, that will be enough.
Hi @Sergei,
I changed the connector from Sharepoint.contents to Web.contents, it works thank you!
The log-in pop-up will still open when Users will access the Template file for the first time and it will be challenging explain them how to correctly sign in with organizational account but at least they can run the query.
About the source file (aka "Datasouce.xlsx"), are you sure they only need R/O rights and not Edit rights instead?
Thank you,
Emanuele
I changed the connector from Sharepoint.contents to Web.contents, it works thank you!
The log-in pop-up will still open when Users will access the Template file for the first time and it will be challenging explain them how to correctly sign in with organizational account but at least they can run the query.
About the source file (aka "Datasouce.xlsx"), are you sure they only need R/O rights and not Edit rights instead?
Thank you,
Emanuele
Hi Emanuele,
I'm not 100% sure since didn't test exactly, but from common logic R/O shall be enough to query the file.
- I tested it and I confirm! R/O rights on the source file is enough.
Also, the query needs less time to run (of course) so I guess it's a double win!
Thank you very much for your help on solving the case Sergei! Appreciated!
EmanueleEmanuele, you are welcome, glad to help.
Yes, performance shall be much better. Querying entire site you enumerate all files one by one, only after that apply the filter. All together takes lot of time.