Forum Discussion
Web credentials needed every time
Helllo twrigglesworth2 ,
there's a sharepoint connector as well https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder
That looks like it may do the task - how would I point it a SharePoint folder, rather than a local?
Helllo twrigglesworth2 ,
there's a sharepoint connector as well https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder
Thank you - The account I am using is a O365 for the SharePoint - will it prompt every time there a need for a 2FA or should it hold the connection to the SharePoint?
Your suggestion hit the target exactly! Thank you so much for this, took some time to get my head around the process but got my Excel files and have removed and deleted a hand full of times now with no protest from Power BI.
Thanks for the help.