The field does not exist in the database tableau error

Question

I have created a tableau dashboard using MongoDB database. We have 30 fields in the database. I have created line graph which show average income of customer and it was working for the past 4 months but suddenly a week ago it stopped working and threw below error. Tableau error

I have check the MongoDB collection and the field is there. But when I see tableau extract it is not showing the field. I want to find root cause of this and solution as well.

in that week ago, for any reason, did the field slightly changed name or type? is it a dimension or a measure? — Fabio Fantoni, Jun 22 '21 at 07:43
I bet you've already tried to replace/refresh the connection... and in addition to that, could you try to create a new workbook connected to the same source in order to see if that specific field appears or not in your dimension/measure list? — Fabio Fantoni, Jun 22 '21 at 08:26
@FabioFantoni yes. Replaced with new connection, tried creating new workbook to see if I am getting all the fields but in new workbook the issue persist. — Pritesh Gujarati, Jun 22 '21 at 08:36

score 0 · Answer 1 · answered Jun 22 '21 at 09:59

Assuming that you have checked the datasource and the filed does still exists I would try to open the workbook with Tableau Desktop, go to Data => New Data Source and make a brand new data source with the same structure of the one that shows you the error.

After that you can go to Data => Replace Data Source and change the source from the old to the new one. Finally you have to close the old Data Source.

Please refer to these pages of the official Tableau Desktop guide:

I have tried this but the problem is new data source also don't have that field. — Pritesh Gujarati, Jun 22 '21 at 10:23

score 0 · Answer 2 · answered Dec 27 '21 at 10:00

0

You only need to import the data source again and then through data => replace data source and Tableau will automatically apply the sheets job again.

answered Dec 27 '21 at 10:00

Mohamed Essam

1

The field does not exist in the database tableau error

2 Answers2