Forum Discussion
import CSV file with more than 1048576 rows
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.
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
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.
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.
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
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.