Hi,

I currently use excel 2013 and have a dbf file with data that should have a little over 2 million lines. When I drag and drop it into excel, I only get a million lines. Please do let me know how to import it into power pivot since it can handle upto a billion lines.