SSAS Import - The key matched more than one row in the table

[deasons22]

When I try to import an SSAS query I'm receieving this message when attempting to select a measure. 

Any advice would be helpful. 

Thanks,

Sam

[v-danhe-msft]

Hi @deasons22 ,

Based on my research, the error message told that the key didn't match any rows in the table, I suggest you to check the configuration for your data structure in SSAS.

Regards,

Daniel He

[deasons22]

Hi Daniel,

The data structures are fine as I can view it in SSAS as well as in excel.

[deasons22]

Also I forgot to mention this only happens when I'm trying to do an import. If I do a live query everything shows up.