Analyze in Excel losing relationships for filtering

In PowerBI, I've created a couple tables (DateKey and Country-Area) that I use manage relationships to be able to filter on my reports. 

However when I use Anayze in Excel, those relationships seem to be lost for filtering.

Country-AreaDateKey

I'm trying to filter the Analyze in Excel by Area.  It works in PowerBI, but in Excel, it doesn't filter anything.  I get the entire dump of database. 

Also, I'm adding Year in the report to be able to select data by year.  Again, able to do this in PowerBI, but in Excel, the Year column seems to be losing it's mapping and I'm getting 5 duplicate rows except for Year column:

I read other threads, and the Year one seems related to Date column changing format in Excel to General instead of Date, so probably the relationship mapping isn't applying correctly outside of PowerBI.

Not sure why I'm not able to filter by Area which is mapped to Countries though.  I've tried setting relationship both Single and Both. 

Would like to filter the Analyze in Excel Pivot data by Area's that are defined in the table.

Any ideas on how to get this to work (besides creating a column in the main data set)?