Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
and in there, under the tabular section,
Rows in a table | Unlimited 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.
Hi @Anonymous
Sorry, it is not supported in power bi now.
May be you can count the values in SQL.
Best Regards,
Link
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |