Forum Discussion
Helper VNot able to schedule automatic refresh in service.
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.
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:
- Download and install the gateway on a local computer.
- Configure the gateway based on your firewall and other network requirements.
- Add gateway admins who can also manage and administer other network requirements.
- Troubleshoot the gateway if there are errors.
- Add or remove a gateway data source - Power BI | Microsoft Learn
- 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.
5 Replies
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:
- Download and install the gateway on a local computer.
- Configure the gateway based on your firewall and other network requirements.
- Add gateway admins who can also manage and administer other network requirements.
- Troubleshoot the gateway if there are errors.
- Add or remove a gateway data source - Power BI | Microsoft Learn
- 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
Memorable Member
Hi asdf1608 ,
Please let me know what is the datasource and have you configure the gateway for it .
Thanks,
Pratyasha Samal
asdf1608- asdf1608
pratyashasamal . Please help me with this
