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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I think it's not quite that Power BI and Excel can't handle that many rows, it's that they can't parse a CSV file beyond those rows. I'm sure Power BI shares some code with Excel for handling files. I would try changing the file extension and trying to import it as a delimited text file instead of a CSV.

jstupl's avatar
jstupl
Regular Visitor
9 years ago

Hi Anonymous,

Thanks for suggesting a workaround.

 

I tried witching the extension to .txt. I got: "Power Bi only supports Excel, Power Bi Desktop, and CSV files".

 

Excel cannot handle more than 1,048,576 rows. That is the maximum you can have in a worksheet.

 

Best,

Jan

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    jstupl you would of course need to use the query editor for text.

     

    • 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.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        The query editor is only in the desktop app. The online app is really only useful for connecting to things like content packs and other essentially complete data models.