question

ArunRaaman-6281 avatar image
0 Votes"
ArunRaaman-6281 asked CarrinWu-MSFT edited

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

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 you117524-partitioncreationerror.jpg


sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @ArunRaaman-6281,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.