Forum Discussion
Runtime Error Visual C++
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?
3 Replies
- mechanix85Helper I
This error appears after the request has already been processed and a "recount" in Power Pivot
- v-ljerr-msftMicrosoft Employee
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: :smileyhappy:
http://social.technet.microsoft.com/Forums/en/category/officeitpro
Regards
- mechanix85Helper I
hi v-ljerr-msft
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