Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Power bi server version - Export data

  • 1.  Power bi server version - Export data

    Bronze Contributor
    Posted Aug 06, 2019 04:18 AM
    Hi, I build report on power bi server version. My viewers want to export data from my visuals and the maximum  row numbers are only 30000. Can we export data which has more than 30000 rows?
    Thank you. 


    ------------------------------
    Munkhtsetseg Bat-Erdene
    Analyst
    99294837
    ------------------------------


  • 2.  RE: Power bi server version - Export data

    Top Contributor
    Posted Aug 07, 2019 03:19 AM
    Hi @Munkhtsetseg Bat-Erdene,

    There is a limitation to export data from PBI visual. It is 30,000 rows for a .csv file and 150,000 for .xlsx.

    Here is the link to the MS Doc:
    https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

    Hope this answers your question.

    Thank you,


    ------------------------------
    Vishesh Jain
    Owner
    VR Construction
    ------------------------------



  • 3.  RE: Power bi server version - Export data

    Bronze Contributor
    Posted 23 days ago
    Hello,
    You may use R to export up to 150 k lines with this solution :
    https://thebipower.fr/index.php/2019/02/09/export-data-to-excel/
    Regards

    ------------------------------
    Didier Terrien
    Group Data Quality Officer
    ------------------------------