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 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!
Emanuele
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!
Emanuele
Emanuele, 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.