Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Auto Refresh disabled. Data source credentials missing

I am trying to set up a report to auto refresh but I am unable to.

The settings page shows the unknown.png


My data comes from a sharepoint site

Where should I go to fill in these misisng credentials. 


A Gateway is not an option for me, I just need to know where I can add the missing credentials 

Super User
Super User

@airwreck sharepoint is the only source in your file or there is another sources too?

Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Frequent Visitor

Correct data is only coming from sharepoint

Hello, the same thing happened to me when I added to my data model an excel (local) file as an additional source. That generated the same error as the one to show and the only way to solve it was to eliminate the excel from the model.


Hi @airwreck ,


Has your problem been solved? 

You check whether the data source has changed, such as the data file has been deleted.

Because Power BI Service will read your connection information and generate data source credentials, you cannot manually configure data source credentials if your data source is deleted.


If the data source has not changed, try to refresh the .pbix file in PBI Desktop, If it can, please publish the .pbix file again.


Best regards,
Lionel Chen

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

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.