Forum Discussion
Data source credentials and scheduled refresh greyed out
Super UserAnonymous , I saw one more use complain same. First, check it is not asking for a gateway. If so , why it is, check do you have any local files used.
Check Know issues -https://docs.microsoft.com/en-us/power-bi/troubleshoot/known-issues/power-bi-known-issues
Log an issue, if needed : https://community.powerbi.com/t5/Issues/idb-p/Issues
Hi this actually solved my problem. I have both web and local files used in the data model. I can't schedule auto fresh and my data source credentials is grayed out. Google brought me here for my trouble shooting. After removing the local files, the data source credentials becomes normal and scheduled refresh can be configured. I looked it up in ChatGPT. It explained the reasons for this well. Power BI Service doesn't have direct access to files stored locally. Scheduled refresh requires data sources that are accessible over the internet or a network. Even if PBI Servcie could access local files, managing credentials would be cumbersome and insecure. Plus, local files may not always be available or accessible, if you computer is turned off, disconnected from the network, or if the path is changed. In short, scheduled refresh requires data sources that are consistently available to ensure the reliability and accuracy of your reports and dashboards.
Thank you for your insights! Something new I learned today.
Thank you! The local file was the issue!
When you talk about storing files locally, I am a bit confused. I utilize powerbi for files that are stored in my onedrive. does this qualify as "stored locally"?
