Data source refresh is disabled because at least one data source is missing credential

[Suraj_raju]

• • Data source errorScheduled 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 URIWABI-US-EAST2-C-PRIMARY-redirect.analysis.windows.net
  • Activity IDd71d7771-8d0e-4574-9f04-fa688be65ace
  • Request ID07ec2a09-1e60-bbcb-0da0-2766b732c364
  • Time2023-01-04 10:26:58ZCopy

[Chrisspy1]

So I got this issue when I added a excel file to my PBI, credentials were greyed out.  Mine i believe is the permissions linked to the excel file so I got data from Sharepoint folder and narrowed it down to the file then when i refereshed everything was fine.  Hope this helps someone 🙂 

[mukul_goswami]

i am also getting same issue in my Usage metrix report now i want to reactivate schedule refresh how can i do this please help!!

[MicaD]

Hi, I've been getting this error the last 2 weeks and need to go into the report and refresh the data to get the data to update. Once inside the report in desktop app it works but the scheduled refreshes don't work and I can't re-fresh on demand in the web service either. I get this issue: 

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-WEST-EUROPE-redirect.analysis.windows.net
Activity ID:	2a3a83cf-89e8-4c41-8620-48640636dd5c
Request ID:	8822eb07-e1c9-806d-0e7d-b2011ae8e63e

[Anonymous · Accepted solution]

Hi @Suraj_raju ,

Seems to be an issue with data source credentials. 

Please check that all data source credentials have been entered and validated.

Please  go to this dataset's settings page and enter credentials for all data sources.

Configure scheduled refresh - Power BI | Microsoft Learn

I have also found a similar post, please refer to it to see if it helps you.

Solved: Scheduled refresh is disabled because at least one... - Microsoft Power BI Community

•  I forgot to add the mapping of each data source as you can see in the screenshot, the "Maps to" is empty. 

Solved: Scheduled refresh is disabled because at least one... - Microsoft Power BI Community

• For One drive no gateway need but for Active Directory Yes ( Personal Gateway ) this is what PBI Service is throwing at me when I tried to do an on-demand refresh. I setup the gateway looks everything is working fine .

If it still does not help, please provide a screenshot with the error.

Best Regards
Community Support Team _ Polly

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

[skahlon13]

I generated this report and don't even have the option to refresh/enter credentials. Im pulling data from oracle database and a microsoft teams web link. Any help would be appreciated

[Muhd_Aslam2024]

Hi Power BI Team,

I have a similar issue on my side when I want to open up my PowerBI from my company's MS team. 

I've also tried to login using the right credentials to the DB but still to no avail. 

Kindly please advise.

Thank you!

[GrimRipper]

Hello,

I am also facing the same issue. But when i go to setting my Data Source and Credentials option is greyed out so i am not able to update the credentials of data source. 

[NOTE:- I am trying to refresh the dataset using Power Automate as refresh option in Power BI service is greyed out too.]

Can you please help me out with this ??

[Sudhir433]

I am receiving following error message when i try to update the credentials and signin in dataset settings page

[Suraj_raju]

I keep getting this error while i'm trying to connect a json source data which is in a remote server, i can refresh it in power BI desktop but once publish there is'nt option to refresh it, kindly help me out on this,thanks