Issue while trying to create a sample partition in SSAS Tabular Model with DirectQuery mode

Question

Hello There,

I am trying to create a sample partition to a tabular model database in DirectQuery mode, and I got the following error after setting the filter and trying to import:

"Failed to save modifications to the server: Error returned: 'A table that has partitions using DirectQuery mode and a Full DataView can have only one partition in DirectQuery mode. In this mode, table 'FactInternetSales' has invalid partition settings. You might need to merge or delete partitions so that there is only one partition in DirectQuery mode with Full Data View."

Would anyone please help me understand the issue. Thank you

Answer 1

Hi @ArunRaaman ,

Welcome to Microsoft Q&A!

SSAS Tabular supports multiple partitions per table, but DirectQuery mode can only access data in a single partition. And the error returned: 'In this mode, table 'FactInternetSales' has invalid partition settings. You might need to merge or delete partitions so that there is only one partition in DirectQuery mode with Full Data View'. So you should check the partition of table 'FactInternetSales'. Please refer to Define partitions in DirectQuery models to get more information.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.