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.

jstupl's avatar
jstupl
Regular Visitor
9 years ago

Anonymous

 

I cannot find that option in the online app. I only see the "Get Data" option, which leads to "Files" gave me the error message above.

 

jstupl's avatar
jstupl
Regular Visitor
9 years ago

Anonymous, Anonymous, Greg_Deckler,

 

I appologize for leaving out an important detail in my original post: I was using the online version of Power BI. After my experiences, I am still convinced that there is a restrictions to the number of rows I mentioned originally.

 

However, I just downloaded the desktop version and it can actually deal with the full 4 million lines.

 

Thanks for your help,

Jan

 

 

  • jstupl's avatar
    jstupl
    Regular Visitor
    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.