Forum Discussion

Nari's avatar
Nari
Regular Visitor
9 years ago

Data source error: The 'stageid' column does not exist in the rowset.

our regular scheduled refresh keeps failing either by on-demand/scheduled refresh

by throwing following error

 

Data source error:The 'stageid' column does not exist in the rowset.

 

but we havent come across any column with stageid namein our data source.

can anyone had this before or could help us resolving the issue

 

thanks

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    I had a very similar issue and was able to resolve it by renaming the column to something different.  In my case I renamed my "Stage id" column to "ID" and it worked.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Worked for me also this renaming trick 😄

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Have a look in the Query Editor and see whether StageID is being used as part of your steps in getting the data from the Source into whatever tables you are using for your reports.  Perhaps StageID used to exist and was being removed by "Remove Columns" but now its no longer in your data source.  Maybe StageID was being created as part of this process, but was no longer needed so the step was removed but a later step is referring to it.