Gateway data refresh error

[Anonymous]

Everytime i publish a report and try to schedule a refresh it fails every single time with the same error 

*The 'AddedWhen' column does not exist in the rowset. Table: Products.*

I have gone through all the tables and made sure they are date columns etc, but after i do this i get an error saying it cant find the column.

Please help, am really struggling what else to do with this?

[v-lili6-msft]

hi, @Anonymous

     I have tested on my side, but not reproduce the issue. and I search many articles about the issue.

It seems that delete the offending column, rename the column to something different,

Renaming report, upload/republish .ect can help solve this.

hope these can help you

Reference:

https://community.powerbi.com/t5/Service/The-column-does-not-exist-in-the-rowset/td-p/327629

https://community.powerbi.com/t5/Service/The-HasUniqueRoleAssignments-column-does-not-exist-in-the-rowset/td-p/174257

https://community.powerbi.com/t5/Service/Data-source-error-The-stageid-column-does-not-exist-in-the/td-p/139068

https://community.powerbi.com/t5/Service/Data-Source-Error-The-yes-it-does-eixst-column-does-not-exist-in/td-p/180076

Best Regards,

Lin

[Anonymous]

Hi @v-lili6-msft no none of this helps as if i rename the columns i then get an error saying it cant find that column. It seems a lot of people have this issue but microsoft dont really have much help about it