Forum Discussion
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
|
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,
5 Replies
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,
ibarrau
DataSource Credentials look like thisMy data source
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,
