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 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
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |