Forum Discussion
Scheduled Refresh Failed - missing credentials - Data source credentials greyed out
I was able to resolve this.
One of my data sources was an Excel spreadsheet from my OneDrive. In "Data Source Settings", the line corresponding to that Excel file had the path to the file on my local machine. I opened the file in sharepoint, copied its URL, and replaced that line in Data Source settings by the URL. This resolved my issue.
I was able to resolve this.
One of my data sources was an Excel spreadsheet from my OneDrive. In "Data Source Settings", the line corresponding to that Excel file had the path to the file on my local machine. I opened the file in sharepoint, copied its URL, and replaced that line in Data Source settings by the URL. This resolved my issue.
I was able to figure out how I had fixed this issue using morgangrobin's answer. I had previously copied the excel data and pasted it into PowerBI Desktop (thereby, "entering" it in). This does the trick. However, if you're data sheet is live (i.e. it gets updated regularly, particularly by others) than I would recommend morgangrobin's solution as a more general option.