Forum Discussion
Solved
Web credentials needed every time
Hello, We have a Power Automate that generates an Excel document, that is then saved on SharePoint and read by Power BI. When the Excel is created, it deletes the existing one and creates a new...
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.