Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Scheduled refresh not working

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

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        Anonymous
        Not applicable
        5 years ago

        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.