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 there!
I'm trying to apply the code below for a table with 150.000 rows, and my app is crashing, out of memory.
I'm using a i7-3770 processor with 16 GB RAM. Is it normal? Is there anything I can do about?
Column = CALCULATE ( COUNTROWS ( TableName ), FILTER ( ALLEXCEPT ( TableName, TableName[Name] ), TableName[ID] <= EARLIER ( TableName[ID] ) ) ) - 1
You may be hitting the Power BI data load limit.
Go to options -> options and settings -> data load increase maximum allowed.
Hopefully this helps.
Thanks for helping, cthurston. It was a good suggestion.
But I changed it to 99.999.999.999 and the problem remains.
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |