The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
|
Solved! Go to 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,
Happy to help!
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,
Happy to help!
@ibarrau
DataSource Credentials look like this
My 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,
Happy to help!
I think it's net work, Because I didn't install the gateway it didn't show that right?
it's power query M function that right?
idk what is I using Web.Contents or something else for the connections?
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,
Happy to help!