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
Hello twrigglesworth2 ,
I would suggest you read from a folder in power bi, so you let power automate send the excel to a specific folder online and you always read what's in a folder.
Would you be able to advise how I can set that please - I'm not very skilled in Power BI