Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

SSAS: How to solve column of table cannot be processed bcz it contains more than 2B distinct records

Hello All,

 

We are using SSAS tabular models for our power bi reports.

Our models are pulling data from SQL Server and the data is increasing rapidly in billions.

One of facttable, which has more than 10Billions of records, when we are trying to process that table,

we got below error

The ''column" of the ''table" cannot be processed because it contains more than two billion unique values. 

The column which we got this error is a decimal data type

 

But earlier also we got the same error on a string column, and we resolved it by splitting the column into two, and using those two columns in report by concatenating through measure.

 

I have gone through below url

https://docs.microsoft.com/en-us/analysis-services/multidimensional-models/olap-physical/maximum-cap...

and in there, under the tabular section,

Rows in a tableUnlimited

Warning: With the restriction that no single column in the table can have more than 1,999,999,997 distinct values.
 
 

Now, my question is, how we can keep a check on our table columns, where we can know that, any of the our table's column is reaching the limit of 2B distinct values, so that we can take prior action on it to resolve.

 

Any suggestions or tips and tricks would be very helpful.

 

Thanks,

Mohan V.

 

 

 

1 REPLY 1
v-xulin-mstf
Community Support
Community Support

Hi @Anonymous

 

Sorry, it is not supported in power bi now.

May be you can count the values in SQL.

 

Best Regards,

Link

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.