Forum Discussion
Exporting Jupyter Notebook data as Xlsx file
Hi William__K ,
The maximum number of rows that Power BI Desktop and Power BI service can export from an import mode report to a .csv file is 30,000. It's by design.
Do you necessarily need to export a .CSV file for use in Power BI?
You also can tell compelling data stories with Power BI in Jupyter notebooks. Get your Power BI analytics in a Jupyter notebook with the new powerbiclient Python package.
For more information，you can refer to：
Announcing Power BI in Jupyter notebooks
How to Optimize Your Jupyter Notebooks with Embedded Power BI Reports
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply, I have been using the Power BI client in Jupyter Notebook but I was hoping to export more than 30000 rows to a data frame to manipulate. My question may not have been well phrased initially.
Hi William__K ,
As far as I know, currently you cannot export more than 30,000 rows of data from a report in import mode to a .csv file in Power BI. This is by design.
You may also vote the idea and comment there to improve Power BI. It is a place for customers provide feedback about Power BI products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Hope it helps,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
