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

[starsoul]

Getting below error message without the name of the table. I have around 100 table in the model and most of them have a description field as a column. Now don't know how to find which table is causing this issue. Refresh all data works fine in Power BI Desktop app. Last time when I encountered this problem, I started deleting tables 1 by 1 and I figured out which table is causing service to fail. Then I refreshed that table manually and published it again and it got fixed. But now again am getting this issue for some other column. I can't delete tables every to find which table this error is referring to, its very time consuming. It should share the Table name which this column doesn't exist. Database used here is MYSQL. As I have mentioned earlier not sure why BI Desktop doesn't through this error only service starts getting failed for refresh.

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

Cluster URI: WABI-INDIA-WEST-redirect.analysis.windows.net

Activity ID: xxxxxxx

Request ID: xxxxxxx

Time: 2021-08-21 11:07:35Z

[v-xulin-mstf]

Hi @starsoul

Currently there is no support for retrieving to which specific table there is a problem.

For your current problem, please refer to this post and check if you have a similar operation.
As a workaround, you can narrow it down to a table with similar actions.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[starsoul]

@v-xulin-mstf Thanks for responding. Without table name information its anyway difficult to find the problematic table when you are dealing with 100+ tables in a model. So in some logs it should provide the table information where service found the issue, which it does in other scenarios. From Microsoft support they shared list of few tables which helped. 

[v-xulin-mstf]

Hi @starsoul

Okay, looking forward your good news!

It would be great if you could share the solution with us!

😉

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[Greg_Deckler]

@starsoul 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".

[starsoul]

@Greg_Deckler This issue is not listed. I have created another post for the same and also raised a support ticket with Microsoft. Thank you for responding.