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
Hello twrigglesworth2 ,
this is the folder connector, you can learn all about it here
https://learn.microsoft.com/en-us/power-query/connectors/foldercheck this as well https://youtu.be/-XE7HEZbQiY?si=9t1J3CHviABMaZOx
That looks like it may do the task - how would I point it a SharePoint folder, rather than a local?
