refresh challenge for directquery and calculated table

Hi, 
Seems the issue is that your additional sellers from Excel don’t have details like city. This makes it impossible to combine them with the DirectQuery table in a calculated table and maintain proper relationships for visuals. 

I see 3 possible options: 

SQL view in the source: 

• If possible, create a view that UNIONs all sellers and includes all necessary details (city, etc.)...This gives you a single, consistent table for slicers and visuals.

Mapping table for additional sellers

• Keep DirectQuery as master...then add a small Excel table with the extra sellers and their details (city, etc.).

• Use relationships + DAX measures to handle the extra sellers in your visuals 

Separate slicer table

• You could create a slicer table with all sellers, but visuals using city/details need measures to handle missing info for Excel only sellers.. 

Hope that helps !! Regards.