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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Tiger2514555
Helper III
Helper III

API Scheduled refresh is disabled because at least one data source

I want to refresh the dataset and it gives this error and I can't set anything in the dataset.
It's error this 

Last refresh failed: 11/2/2023, 5:33:17 PM
Scheduled refresh has been disabled.

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-SOUTH-EAST-ASIA-B-PRIMARY-redirect.analysis.windows.net
Activity ID:9941993c-2b87-40e5-b8a2-bd188a5a61a0
Request ID:1242bcdb-8d8b-da0f-afdc-9d63d991766b
Time:2023-11-02 10:33:17Z

Tiger2514555_0-1698978538184.png

 

Tiger2514555_1-1698978567049.png

 




1 ACCEPTED SOLUTION

That's it. The Address strating with 192.168..... means it's a local api that is not running over the internet. You must use a gateway if you want to connect to that URL. Otherwise Power Bi Service can't read the URL if it doesn't travel through the gateway.

You can learn more about gateway here: https://www.youtube.com/watch?v=Vlv1tbuZNcM

Then for new UI: https://www.youtube.com/watch?v=L18HEAnBqTo

I hope that helps,


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

Happy to help!

LaDataWeb Blog

View solution in original post

5 REPLIES 5
ibarrau
Super User
Super User

Hi. What are your data sources? the message says you need to configure the credentials for them before being able to run the refresh. When using cloud sources, on the same screen of the picture, there is a DataSource Credentials menú that you can use to edit them. If your sources are on premise then a gateway is required and we can talk about how to add the sources for the gateway.

I hope that helps,


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

Happy to help!

LaDataWeb Blog

@ibarrau 
DataSource Credentials look like this

Tiger2514555_0-1699233377137.png

My data source

Tiger2514555_1-1699233477955.pngTiger2514555_2-1699233545051.png

A calendar is a table that I created with code.
And I'm not using the Power BI gateway. What's the problem?

Is that a local API in a network or is a public request that you can run from any computer with internet connection? Because it's weird that the first picture doesn't show anything at "Cloud Connections" and then you have a source with an URL. It should show something there.

If you can't see data source credentials, at least one of the sources might be using a restricted power query M function. For example, web.page is not a function that would let you run a cloud refresh with out a gateway. I think html.table was another one.

Are you just using Web.Contents or something else for the connections?

I hope that helps,

 


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

Happy to help!

LaDataWeb Blog

I think it's net work, Because I didn't install the gateway it didn't show that right?

Tiger2514555_0-1699320535850.png

it's power query M function that right?
idk what is I using Web.Contents or something else for the connections?

Tiger2514555_1-1699320718205.png


when open web
What shoud I do.
@ibarrau 

 

That's it. The Address strating with 192.168..... means it's a local api that is not running over the internet. You must use a gateway if you want to connect to that URL. Otherwise Power Bi Service can't read the URL if it doesn't travel through the gateway.

You can learn more about gateway here: https://www.youtube.com/watch?v=Vlv1tbuZNcM

Then for new UI: https://www.youtube.com/watch?v=L18HEAnBqTo

I hope that helps,


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

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.