Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

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 causin...
Need Help
v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous

 

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!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    v-xulin-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous

     

    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!