Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello. I have a query (table1) with a lot of merges (about 6). The file with the information for 1 year contains 7 000 000 lines. There is another table (table2 300 000 lines). There are also computational columns: summation from table 2 using FILTER. There are also additional calculated columns.
Recently, a bug (in the attachment) began to appear when trying to load information into the model for 1 year. Previously, I downloaded without problems and 2 years.
Nobody faced with this?
Hi @mechanix85,
According to the error message, it seems to be more related to an Excel issue. So I would suggest you post it in the following link below and check if it helps: ![]()
http://social.technet.microsoft.com/Forums/en/category/officeitpro
Regards
The fact is that when I load information from 1,000,000 rows, there is no error. However, I noticed that the ekzel for a long time produces calculations in the POWER PIVOT after the information is loaded there
This error appears after the request has already been processed and a "recount" in Power Pivot
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 37 | |
| 35 | |
| 35 | |
| 28 |
| User | Count |
|---|---|
| 134 | |
| 101 | |
| 71 | |
| 67 | |
| 65 |