Power BI report Refresh failure in Power BI web service

[Anonymous]

I have created one power bi report linked to sharepoint lists. When i am changing data in SharePoint lists, sometimes report refresh is failing and sending me email like "The 'Pending Verification' column does not exist in the rowset. Table: Agent SystemRole Map ". Although when i am going to power bi desktop and refreshing the report and preview, no error is coming and it is working fine. But still it is failing when i am trying to refresh the dataset from power bi web(https://app.powerbi.com/). Please assist and let me know that why this dataset refresh is getting failed in power bi web as it is working fine in desktop.

We are not changing any column name in SharePoint list and Pending verfication is a field in status column which include other fields such as New,Open, verified etc and i am doing unpivot of this column hence each status is getting created as a column such as New, Pending Verfication column etc. Apart from that nothing else i am doing with this data. 

Refresh is working fine when i am doing from Power BI desktop but is failing only in Power BI web sometimes.

[v-lionel-msft]

Hi @Anonymous ,

"The 'Pending Verification' column does not exist in the rowset..."

Did you make any changes to this column in the data source?

Best regards,
Lionel Chen

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

[Greg_Deckler]

@Anonymous - Super difficult to troubleshoot. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".