Forum Discussion
Need help with large data sets
Hi all wondering if someone can help me with a solution! We have 10+ suppliers that send us multiple excel spreadsheets on a monthly basis with millions of lines of data. The data unfortunately doe...
Thanks for the reply
Can I ask though, when I create a query and then want to present the results or produce a pivot etc, if the results are 1m+ lines will this cause an issue for excel?
Can I ask though, when I create a query and then want to present the results or produce a pivot etc, if the results are 1m+ lines will this cause an issue for excel?
Aread62127 No problem, you can load the data into the Data Model. More about that in, for example, the link below: