Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
456 questions
Get record count of Partition
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 98%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
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.
{count} vote
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee2020-12-11T23:30:32.597+00:00 Hello @Bowles, Mickey ,
Thanks for the ask , are you using Azure analysis service or SQL Analysis services ?
Thanks
Himanshu -
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
2020-12-17T22:52:21.363+00:00 Hello ,
We have not heard back from you on this and was just following up .
Incase if you have resolution , request you to share the same here , so that other community members can benefit from that .
Thanks
Himanshu -
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
2020-12-23T20:04:54.513+00:00 Hello ,
We have not heard back from you on this and was just following up .
Incase if you have resolution , request you to share the same here , so that other community members can benefit from that .
Thanks
Himanshu -
Bowles, Mickey 46 Reputation points
2021-01-06T19:05:42.757+00:00 Azure analysis services via azure function (C#) on a schedule.
What I need is a way to double check those existing partitions that are ObjectState.Ready and if row count is 0, run this on itpartitionToProcess.RequestRefresh(RefreshType.DataOnly);or RefreshType.Full. Either way, we end up with some partitions (calculated) with 0 rows due to a source system issues and need to refresh them in case the source data is ready now.
Sign in to comment
Sign in to answer