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

[Nari]

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

[Anonymous]

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]

Worked for me also this renaming trick 😄

[Anonymous]

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.