Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
YT84
Frequent Visitor

Data source and scheduled refresh error: at least one data source is missing credentials

Hi there.

 

Trying to make the offline report work in Power BI service.

My report is using an API query to get data from Youtube via Supermetrics (response is in JSON format).

 

When I upload the file to Service and try to refresh the data source I get the following error message:

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.

 

Since the API key is embedded into the query, I am using the "Anonymous" type of connection.

YT84_0-1647966514547.png

 

I can't really understand where to fix this issue.

Could someone please suggest at least a direction?

6 REPLIES 6
GilbertQ
Super User
Super User

Hi @YT84 

 

Can you got into the data source settings and configure the data source settings by clicking on Edit Credentials in the Power BI Service for Web

 

GilbertQ_0-1647984233822.png

 





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

Proud to be a Super User!







Power BI Blog

Hi all,

I have the same problem with a work made with Power Bi Desktop, where there are 2 query by Web API call and the authentication is by Api Key. After publication on-line I tried to change dataset authentication but Api key is missing. 

YT84
Frequent Visitor

Hi @GilbertQ 

No, this option is inactive for me. Is it available only with a Premium subscription?

YT84_0-1648036287111.png

 

Hi @YT84 


That means you would need the gateway to configure your data source refreshing!





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

Proud to be a Super User!







Power BI Blog

YT84
Frequent Visitor

Hi @GilbertQ .

Could you please explain a little bit?

As the description says here the gateway is intended for on-premises use.

How can it help me connect to a "live" API of Supermetrics from Power BI Service?

And does it mean that I will need to have my PC running for the refresh to work?

Hi @YT84 

 

Yes even though it says it is intended for on-premise use in some instances it considers an API call like an on-premise source. So you will have to use the gateway.





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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors