Schedule refresh

[MKYZ22]

I am receiving this error :

The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

{"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"Cloud data source refresh is not allowed in gateway setting."}}],"exceptionCulprit":1}}} Table: Total Calls per day.

Also note :

one of data source is google sheet

manual refresh is working well,

I tried to download gateway again

If any one can help, thanks

[Anonymous · Accepted solution]

Hi @MKYZ22 ,

According to your descriptions, your data source is a mixed data source, include On-premises data source and Cloud data source. Please download and install gateway, then merge or append on-premises and cloud data sources in the same query, then set the schedule refresh policy.

For more details, you can read related document: Merge or append on-premises and cloud data sources - 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.