'The current query cannot be evaluated for the '<ccon>Payment Measures (37)</ccon>' table, because the table contains more than two billion rows.

Question

Hi,

We start to get the following errors this week but we have more than two billion rows for years and only have issue start from this week.

Is there any new update happening in recent day?

Here is the error:

Invoke-ProcessASDatabase : Failed to save modifications to the server. Error returned: 'The current query cannot be evaluated for the '<ccon>Payment Measures (37)</ccon>' table, because the table contains more than two billion rows. Technical Details: RootActivityId: b349d7b6-bc92-4382-936a-c5d59333f060 Date (UTC): 4/27/2024 8:58:23 AM '. At line:150 char:5 + Invoke-ProcessASDatabase -DatabaseName $DatabaseName -RefreshType ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (PaymentTransactions:String) [Invoke-ProcessASDatabase], OperationException + FullyQualifiedErrorId : Microsoft.AnalysisServices.PowerShell.Cmdlets.ProcessASDatabase

Answer 1

Can you try live connection to SSAS Tabular?

And within your Tabular model, can you try DirectQuery when connecting on-premise data source?

Based on the documentation, no single column in the table can have more than 1,999,999,997 distinct values.

So in your case try to filter the data :)