Schedule Refresh Issue

[jmiridium]

Can't schedule a data refresh. The following appears:

You can't schedule refresh for this dataset because one or more sources currently don't support refresh.

These are all SQL Server instances. Why can't I refresh this?

[GilbertQ]

Hi @jmiridium

It could be that the data source name that you used to configure it in the Power BI Service under Gateways is not the identical same name as your Server name.

Below is a blog post below, and whilst it refers to an Oracle database it will be the exact same process for a SQL Server.

https://www.fourmoo.com/2017/04/26/power-bi-on-premise-gateway-configuration-steps-to-an-oracle-data...

[jmiridium]

These data sources were working. The data source in this report works in another report. This is an unstable behavior that needs to be addressed

[v-sihou-msft]

@jmiridium

Did you include function with parameters your Power Query? 

Currently, refresh is not supported for functions. You can vote this idea. Please refer to threads below :

https://community.powerbi.com/t5/Integrations-with-Files-and/Can-t-schedule-a-refresh-for-Web-data-m...

https://community.powerbi.com/t5/Desktop/You-can-t-schedule-refresh-for-this-dataset-because-one-or-...

https://community.powerbi.com/t5/Service/You-can-t-schedule-refresh-for-this-dataset-because-one-or-...

Regards,

[jmiridium]

No functions. This report was working and now has stopped