Storage Mode: Mixed (DirectQuery & Import)

[Tmk123]

I would like to connect to a PBI Semantic Model and bring in other tables from other sources (i.e. AWS).  I brought in a table from AWS (import mode) and it's creating a limited relationship due to mixed mode, which I do not want.  

How can I connect to a PBI semantic model in Import Mode?  You cannot simply change anything connected to a Semantic model to Import Mode because it is greyed out.  Thanks for the help!

[Tmk123]

Thank you so much.  That was very easy!

[lbendlin · Accepted solution]

How can I connect to a PBI semantic model in Import Mode?

Every time you do that a little kitten/puppy dies.  Use the "Analysis Services"  connection and specify import mode. Then indicate which of the cube tables you want to import.