Power BI is saying my data source is missing credentials.

[JRTV]

This is the full pop up:

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.

The data source is an excel file from work and I am using it in a Power BI report. I am trying to make it auto refresh so I don't have to mess with every day. I don't know where to look to fix this issue. 

[SamWiseOwl · Accepted solution]

Hi @JRTV 

Did you connect via the Excel connector, the Web connector or some other connector?

If the file is in the cloud (OneDrive, SharePoint etc) you can connect without a GateWay.

Whereas if the file is in a local drive you will need a Gateway which makes it worse.

[christinepayton]

This is normal after publishing a model the first time. After you enter them in the cloud once, they should "stick" after that. It shouldn't ask you every day thereafter--

[SamWiseOwl]

I recognise that name @christinepayton ! I love your YouTube channel!

[christinepayton]

aw thanks! 😄

[SamWiseOwl · Accepted solution]

Hi @JRTV 

Did you connect via the Excel connector, the Web connector or some other connector?

If the file is in the cloud (OneDrive, SharePoint etc) you can connect without a GateWay.

Whereas if the file is in a local drive you will need a Gateway which makes it worse.

[JRTV]

I got the data from Excel Workbook that is in a TEAMS group. Should I have saved it to the cloud first (the excel workbook)?

[SamWiseOwl]

Which connector did you use?

If it was Excel your connection will look like this in the Query Editor under Source:

Meaning it is refreshing through your computer and not through the Web.

[JRTV]

It is from a onedrive. 

[Anonymous · Accepted solution]

Hi @JRTV ,

Please refer to the documentation for steps:

SharePoint and OneDrive for Business files import

And make sure you select OAuth2 as the Authentication method when configuring your refresh settings.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum