Forum Discussion
Solved
Unable to auto refresh Dataset using Power Automate due to Data Source Credentials being greyed out
Hi, I have multiple Datasets being refreshed by Power Automate in my organisation where the data source is a Sharepoint List. With these i get the following. All works fine. However ive...
Yes however i think i found the solution. I needed to get data in power bi from 'Web' and insert the local path URL of the spreadsheet found in the file Info section. This way Power bi points to the correct path without needing a gateway. Now i see options for credentials. I just need to configure credentials and hope it works.
Working. Hope this helps others. Thanks for assistance.