Not able to schedule automatic refresh in service.

[asdf1608]

I published the report in app.powerbi.com. WHen tried to schedule automatic refresh it was like this

So I searched for what is the issue and found that datasource was not connected

So I edit the credentials and gave sign in. More that 4 hours passed still it was not sign in and it kept loading.

I am not able to set automatic refresh.

Help with this is appreciated.

[v-binbinyu-msft · Accepted solution]

Hi @asdf1608 ,

If your data source is On-premises SQL Server, you need install gateway firstly.

Please try below steps:

1. Download the latested gateway, install and configure

2. Create a datasource in Power BI Service for SQL Server

3. Open dataset, under the "Gateway  connection" tab, select the gateway and map the data source

4. Create the schedule refresh policy

For more details, you can read related document: 

1. Download and install the gateway on a local computer.
2. Configure the gateway based on your firewall and other network requirements.
3. Add gateway admins who can also manage and administer other network requirements.
4. Troubleshoot the gateway if there are errors.
5. Add or remove a gateway data source - Power BI | Microsoft Learn
6. Manage your data source - SQL - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pratyashasamal]

Hi @asdf1608 ,
Please let me know what is the datasource and have you configure the gateway for it .
Thanks,
Pratyasha Samal 

[asdf1608]

@pratyashasamal The datasource is SQL and for Gataway

It is like this

[asdf1608]

@pratyashasamal . Please help me with this

[pratyashasamal]

Hi @asdf1608 ,

You can setup the gateway .
Please follow these link :-
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install
Hope it helps.
Thanks ,
Pratyasha Samal 
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C