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
Unfortuantely Data source credentials is completely grayed out
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