cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MohanV
Helper III
Helper III

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 @MohanV

 

Sorry, it is not supported in power bi now.

May be you can count the values in SQL.

 

Best Regards,

Link

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!