Linking to large dataset RRS feed

  • Question

  • I am trying to combine two addins, power pivot and fuzzy search. I am trying to match customer name to an account lookup table of approximately 4MM records.  I am going to get customer name, address, city, zip from my customer in a flat file and I want to be able to find the best choice from the 4MM records. Has anyone done something of this magnitude or should I look at something out of SQL Server?

    Tim Vavra

    Thursday, February 11, 2016 2:38 PM


  • I have put millions of records into Power Pivot but you might have better luck with doing something like DirectQuery to SQL Server or Azure SQL Database or Azure SQL Data Warehouse.
    Friday, February 12, 2016 12:51 AM