Forum Discussion
Automated refreshes
Grayed out usually means one of these:
1. You're not the model owner. Only the owner can edit Service credentials. On the model's Settings page, click Take over, refresh, then try again.
2. Dynamic data source in your M code. If the file path is built with variables or concatenation (e.g. Web.Contents(baseUrl & "/" & date)), the Service can't pin down the source and grays this out. Fix: hard-code the base URL as a string literal and move variable parts into the RelativePath / Query options of Web.Contents.
3. Stuck refresh. Wait 10 min, hard refresh (Ctrl+F5), or try incognito. (I don't think it's likely it)
Most likely #1 if someone else published, #2 if the path has today's date in it
If this helped, a thumbs up and accepting the solution would be appreciated.
Thanks,
Shai Karmani
1) Go to the Power BI Service → find your workspace → click the three dots next to the semantic model → Settings.
2) Under Data source credentials, expand each data source listed. You will see a prompt to edit credentials for each one.
3) For the OneDrive source, select OAuth2 as the authentication method and sign in with the account that has access to the OneDrive files.
4) If you have any other data sources (database, web, etc.), configure those credentials as well. Every data source must have valid credentials in the Service before scheduled refresh will work.
5) After all credentials are set, go back to the Scheduled refresh section in Settings and toggle it back on.
Data source credentials is greyed out and not able to be selected per my previous reply
are you the model owner? You need to be to make that change.
