Forum Discussion

William__K's avatar
William__K
Frequent Visitor
4 years ago

Exporting Jupyter Notebook data as Xlsx file

Is it possible to export the report data embedded in Jupyter as a xlsx file rather than a csv. 30000 rows is a little restricting.

General Comment
Need Help

5 Replies

    • William__K's avatar
      William__K
      Frequent Visitor
      4 years ago

      There is a Power BI client made for Jupyter Notebook and the data can be exported directy to it. But by default it exports as a csv which can be limiting for larger reports

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

    • William__K's avatar
      William__K
      Frequent Visitor
      4 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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 _ Caitlyn

        If this post helps then please consider Accept it as the solution to help the other members find it more quickly.