Data Source Credentials - not being able to enter

[kausdutt]

Something went wrong
Scheduled refresh has been disabled.
Please try again later or contact support. If you contact support, please provide these details.
Data source 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.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: 59ccc9e3-a222-4380-960b-3282c657440e
Request ID: d4d543dc-1662-4b93-bf8c-1d44850c9d4b
Time: 2019-09-27 16:03:32Z

[venal · Accepted solution]

Hello Kausdutt,

Hoping that there would be some credentials issue.

Please try to opne the PBIX file in Power Bi Desktop and evaluate it.

Path:- Power BI Desktop >> File >> Options & Settings >> Options >> Clear Cache.

Home >> Edit Queries >> Edit Queries >> Refresh Preview >> Refresh All.

Click on Close and Apply.

Refresh the visuals in Home tab and save or save as the file, Publish it.

Now check with Refresh Now/Scheduled refresh. If you get any error, please click on the data set settings >> Data Source Credentials (please refer the above pic) >> Click on "Edit" and evaluate with the right credentials and try with refersh now.

If you get the same error, please post the error details to investigate more.

If this post helps, then please consider Accept it as the solution to help the other members find it more

[Anonymous]

Hello,

I am establishing a connection with Web & fetching data via API.

I have performed the mentioned steps by you. Refresh is working fine in Power BI Desktop , but post publishing to Power BI service refresh fails & gives the same 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.)

Permissions set:

Type:Anonymous

Privacy Level: None

I believe in this scenerio we don't need to add it to gateway as it's a cloud Data source

Please suggest further steps to resolve the issue

Regards,

Ashish

[Jayendran]

Hi @kausdutt ,

If you are using gateway, then please make sure that you configure your dataset corresponding to your gateway to enable the scheduled refresh.