error when creating a partition (following simple example from book)

Question

I am following a basic example from the book "Hands-On SQL Server 2019 Analysis Services", I am creating a partition, because I am using DirectQuery and I don't want to retrieve all data right now since I am only modelling.

I get the below error:

How can I fix this?

Answer 1

Hi,

As the error info suggested, in the "Fact Sale" table, you need to check all the partitions and set them with Sample DataView property, left only one table with Full DataView property.

If this not resolves your issue, please leave more information about your model or what steps you have done or set for the model.

Regards,
Lukas

---

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.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November