Solved: Storage Mode: Mixed (DirectQuery & Import)

Tmk123 · ‎05-01-2025

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!

lbendlin · ‎05-01-2025

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.

View solution in original post

Tmk123 · ‎05-01-2025

Thank you so much. That was very easy!

lbendlin · ‎05-01-2025

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.