The query with Semantic doesn't include result as expected

Question

Hi Team，

What I've done

1. I've connected datasource with azure db , there is a work location field for each document.
2. I've created one semantic configuration with location city as content field
3. I'm querying the index using the Azure portal, enabling Semantic configuration with the created configuration
4. I'm getting results that don't include the results I expected if semantic search worked

I'll give some examples:

1. I have 2 documents, one includes the location "San Francisco" and the other "palo alto". I assume that when I query, semantically, the text "San Francisco bay area", I'll get both documents in each query. But - I get only one "San Francisco" document, the corresponding one, in each query.
2. When I query the text "New York Metropolitan Area" I didn't get the city in this area except New York city.

Best,
Feeby