Dear all,
I'm using a mixed model with a direct query connection to a sql server analysis service table. I have changed the table by adding a column. The problem is that I can't update the table in the mixed model so that the extra column is visible. The work around is to add the same table again and then I see that the table is update. Disadvantage is that I connect multiple times to the same table
Mixed model screenshot
mixed model: DirectQuery storage mode | missing attribute
Once you have an import data in the pbix, try use Import mode to connect AS database in order to create the composite model.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
