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,
I have a table that have 150 million rows and it needs to cross join with a table with 180 rows.
I worte a dax and create a table. It is faster than Power query editor or SQL but it takes one hour to refresh in Power BI Desktop.
Do you have any suggesttion to improve the performance?
Or any other soultion that will have the same result?
Thank you.
@Nicki , crossjoin is a costly operation. 150M *180 is a big number.
In file->options and setting -> option under data load, increase cache memory. Also, increase the virtual RAM of the system and try
Cache memory is maximum. Thank you for response.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |