Forum Discussion
Anonymous
4 years agoNot applicable
Data source credentials and scheduled refresh greyed out
HI folks, I've seen many posts on this subject but none I've been able to apply. I have a DB in Azure and connect to the server/db thru PBI desktop. I am able to refresh the report visuals throu...
vodka_ATX
1 year agoNew Member
Hello Power Peeps,
I am troubleshooting this issue. In my case I think the problem is due to an Excel file on a network share. The data source is listed as X:\filepath\filename.xlsx but should be \\servername\sharename\filepath\filename.xlsx
I think the solution is to open the PBIX file in Power BI Desktop and edit the datasource connection, save and republish.
Note: I tried the "take over" between two different accounts, mine and an admin account. That didn't fix the issue. That's when I noticed the path to the Excel file was listed as a mapped drive instead of the UNC path.