Map service with joined tables

Question

Is it possible publish a map service to portal with joined tables?
I have a arcpro document with many layers (feature classes). Each layer is symbolized  based on the field of its joined table. When I try to publish a map service the join does  not work.

I have ArcGIS enterprise with a local server, my ArcPro is 2.9.

Thank you

TanuHoque · Answer

thanks @YasnaiaMassie for providing the illustration.

how do you know map service is not honoring the join? Do you see fields from the joined table in the layer REST resources? if you submit a query request with outFields=*, do you see all fields from left and the right side of the join in the result?

YasnaiaMassie · Answer

Here is an illustration what I've been doing which is not working.

ZachBodenner · Answer

Yes, I've had some issues with using a feature class symbolized on a joined table as a Feature Service in a web map. Are you trying to add it to a map as a feature service or a map service? If this is the issue you're having, you may need to use it in the web map as a map service.