Error Automatic Refresh in Power BI Service

[Harvey85]

Hello,

I am having trouble generating the automatic refresh of my dashboard in Power BI from the Power BI Service.

When I update my report from Power BI Desktop it refreshes fine.

I have it set up like this in Power BI Desktop:

And then in Power BI Service it appears like this and it is disabled and grayed out and I cannot configure it:

I am noticing this below Cloud Connections, could it have something to do with it?

Thank you!!!

[v-kongfanf-msft]

Hi @Harvey85 ,

Which connection mode are you connecting to the sql data source?
Once the report is published to the service, you need to configure the gateway, and the appropriate connectors, and make sure the credential information is configured correctly.

For more details, you can read below document:

DirectQuery in Power BI - Power BI | Microsoft Learn

Configure scheduled refresh - Power BI | Microsoft Learn

Best Regards,
Adamk Kong

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

[Harvey85]

Hello @v-kongfanf-msft, I'm connecting to a SQL Server database by "Import" method. Would it be okay?

And also I'm extracting data from an Excel file

[Harvey85]

Update: I installed this with email from Power BI Service:

And then these appeared:

So I edited my two connections and tried updating but still can't because of this error:

Do you know what could it be?

Thanks!