Automated refreshes

[ScrapwareSuppor]

Hello,

I am currently working on setting on reporting metrics for our company using powerBI pro. Currently how I have everything set up is our raw data is automatically saved to OneDrive every morning. currently the automated is not functioning and in the service I get the below error 

"

Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh."

I have already went to Desktop and when to data source settings, edit creds and set to use as current cred and manually entered cred both do not work 

[cengizhanarslan]

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.

[ScrapwareSuppor]

Data source credentials is greyed out and not able to be selected per my previous reply

[cengizhanarslan]

are you the model owner? You need to be to make that change.

[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

[ScrapwareSuppor]

Unfortuantely Data source credentials is completely grayed out 

[Shai_Karmani · Accepted solution]

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