Ideas
Open

Adding table to composite model from Direct Query model

I created a dataset using two existing Power BI datasets using the composite model Direct Query functionality. I then in turn added a new table in one of the two "parent" models. However, when I refreshed the composite model, it didn't pull in this new table automatically. Th existing table that was added through Power Desktop is defined as a "Partition (DQ over AS)" Object Type and the Expression is "Direct Query to AS - {Dataset Name}" I tried to add the table in Tabular Editor by Tables > Create > Table, however, the Object Type is "Partition (Legacy - Direct Query)" and I don't see any way to change the type. Is there a way to update the schema of the composite model to add new tables added from the Direct Query source tables?

0 Comments

Sign in to comment

No comments yet. Be the first to share your thoughts!