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
Credentials configured in Power BI Desktop don't sync to the published dataset in the Service. The Service keeps its own data source credentials, so editing them in Desktop won't clear that error.
In the Service, open your workspace, find the semantic model (formerly dataset) behind the report, click the three dots and choose Settings. Expand Data source credentials and click Edit credentials for each source listed. Sign in (OAuth2 for OneDrive or SharePoint), save, and once all sources show green the scheduled refresh will re-enable.
One thing worth checking: if the report was built against a local OneDrive sync folder like C:\Users\... that path doesn't exist in the cloud and you'll keep hitting auth issues. In that case re-point the query to the OneDrive or SharePoint URL using the Web or SharePoint Folder connector, then republish.
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