Scheduled refresh not working

[Anonymous]

Hi,

For 2 days I have been struggling with the problem of refreshing the data. On desktop version i can easly refresh data without any errors, but when i try to refresh data with scheduled refresh I'm getting below error:

Data source error The 'Product' column does not exist in the rowset. Table: Products_List All

I checked each data source and all columns are present. It make no sense that refresh on desktop version works while service one doesn't. Can someone assists what's going on with Power bi?

Regards,
ksusser

[Anonymous]

Hi @Anonymous 

You can refer to below link which has similar issue:

The 'HasUniqueRoleAssignments' column does not exist in the rowset.

The column does not exist in the rowset

Best Regards,

Rico Zhou

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

[Anonymous]

Thanks for the links, but i've already checked them. If that would be just a missing column then there would be no difference between manual and scheduled refresh. My problem is why scheduled refresh is not working, while manual one does work.

[Anonymous]

Hi @Anonymous 

You can refresh successfully in desktop, but schedule refresh will go failure in Service.

Here I have some advice.

1. Please check your gateway configuration, check whether other reports in your power bi can schedule successfully.

    And please check whether your data source credential is accessful in service.

2. Is there anyone else besides you who has this problem?

3. Please try to republish your report on service and use schedule refresh again.

Best Regards,

Rico Zhou

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