Get record count of Partition

Bowles, Mickey 46 Reputation points

I have a partition processor in C# that creates and loads partitions in a 2 year rolling pattern once a day. When a partition is created with 0 records it is a valid partition and on subsequent loads, the partition state is checked and if Ready, it is skipped. A 0 row partition, unfortunately is ObjectState.Ready. I assumed it would show ObjectState.NoData, but that is not the case. Why is that?

Our data source can be late in providing data and it leaves us with occasional 0 row Partitions that I have to re-run manually. Is there a way to query the Partition to see if it has data? I would like to refresh or rerun if 0 rows.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
435 questions
{count} vote