Forum Discussion

jstupl's avatar
jstupl
Regular Visitor
9 years ago
Solved

import CSV file with more than 1048576 rows

Hi,   I want to upload a CSV file with more than 1048576 rows. It works fine until it hits that number. Suspiciously, that number is also the maximum number of rows for Excel...   Is there way to...
Need Help
  • jstupl's avatar
    jstupl
    9 years ago

    And finally a solution:

     

    1) Import the data with the Power BI desktop app.

    2) Save as Power BI .pbix file.

    3) Import pbix file to online app.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

A couple things that I think would be interesting to try. What happens if you delete one of the columns? Do you get more rows in? Also, what happens if you delete row 1,048,577?

jstupl's avatar
jstupl
Regular Visitor
9 years ago

HiGreg_Deckler,

Thanks for the reply. I cut down the columns by 50% and started at row 1,048,577 . It shuts down after the the number of rows. So this seems to be the upper limit.

 

Best,

Jan