Forum Discussion
Refresh Disabled - The 'X' column does not exist in the rowset. Table: "X"
Hello,
I know that similar topics/questions have arose here before, though the solutions were not helpful in my case.
I am very new to PowerBI, covering this for my organization as previous owner left company. I've had minimial exposure/any training aside from coursework covering the basics: building own reports, sharing with org, etc. Thus, having no success with patchwork/correcting exisiting issues.
Problem: recieving the following error: The 'SBQQ__Theme__c' column does not exist in the rowset. Table: User
It appears that this column has been removed from a Salesforce report, which is fine and to be expected over time. The issue is is that I did not build the report this appears in, thus I am not sure where this is being "fed into". I can not identify where the error is occuring within PowerBI, let alone make the neccessary adjustment to make it "work" again.
Any suggestions/push in the right direction is much appreciated, thank you for your time.
Hi Anonymous ,
You can download the pbix file from the report page in Power BI Service, then open in Power BI Desktop to check which visual is broken in Visual pane or which column is created with incorrected syntax in Fields pane . Then you can determine if add to the visuals or not.
There are similar cases you can refer to :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.
You can also resolve the issue via the troubleshooting link :https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
v-xicaiCommunity Support
Hi Anonymous ,
You can download the pbix file from the report page in Power BI Service, then open in Power BI Desktop to check which visual is broken in Visual pane or which column is created with incorrected syntax in Fields pane . Then you can determine if add to the visuals or not.
There are similar cases you can refer to :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.
You can also resolve the issue via the troubleshooting link :https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.