Forum Discussion

Tmk123's avatar
Tmk123
Helper II
1 year ago
Solved

Storage Mode: Mixed (DirectQuery & Import)

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!

 

 

 

 

 

Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago
    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.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago
    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.