mixed model | direct query | table schema not updated

[Kpham]

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

[V-pazhen-msft]

@Kpham 

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.