Forum Discussion
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 one, same name collums ect but Power BI wants the credentials re-adding
Is there a way to apply credentials that stick or another way of getting the Excels accessible by Power BI?
Helllo twrigglesworth2 ,
there's a sharepoint connector as well https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder
8 Replies
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
