Forum Discussion

Chandrarao's avatar
Chandrarao
Frequent Visitor
9 years ago
Solved

Data Export to Excel limited

A report we have currently has 12-13k rows but when exporting we receive less than 10k rows. We do not know why this is happening. But the current export limits are far greater as far as I know.   ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Chandrarao,

     

    Based on document, I found the size limit is 30k (free user)/150k(pro user).

     

    For more detail information, you can take a look at below article:

    Export data from Power BI visualizations

     

    Limitations and considerations

    •The maximum number of rows that can be exported is 30,000 (for Power BI Free users) and 150,000 (for Power BI Pro users).
    •Custom visuals, and R visuals, are not currently supported.
    •If there is unicode in the .csv file, the text in Excel may not display properly. Although, opening it in Notepad will work fine. Examples of unicode are currency symbols and foreign words. the workaround for this is to import the csv into Excel, instead of opening the csv directly.

     

    Can you share some detail content about your issue?

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Chandrarao,

 

Based on document, I found the size limit is 30k (free user)/150k(pro user).

 

For more detail information, you can take a look at below article:

Export data from Power BI visualizations

 

Limitations and considerations

•The maximum number of rows that can be exported is 30,000 (for Power BI Free users) and 150,000 (for Power BI Pro users).
•Custom visuals, and R visuals, are not currently supported.
•If there is unicode in the .csv file, the text in Excel may not display properly. Although, opening it in Notepad will work fine. Examples of unicode are currency symbols and foreign words. the workaround for this is to import the csv into Excel, instead of opening the csv directly.

 

Can you share some detail content about your issue?

 

Regards,

Xiaoxin Sheng

Chandrarao's avatar
Chandrarao
Frequent Visitor
9 years ago

Thanks v-shex.

 

I will try this and let you know the status.