Forum Discussion
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...
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
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.