Forum Discussion

zeuslyone's avatar
zeuslyone
Frequent Visitor
9 years ago

Error exporting data with underlying data

Every time I try to export underlying data for a report, I get an error: "Error exporting data". I've tried changing the visual (from stacked column to clustered) and even changed the aggregate forma...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

zeuslyone Are you running into any of the known limitations based on the article here? - listed below

 

Limitations and considerations

  • The maximum number of rows that can be exported to .csv is 30,000.

  • The maximum number of rows that can be exported to .xlsx is 30,000 (for Power BI Free users) and 150,000 (for Power BI Pro users).

  • Power BI only supports export in visuals that use basic aggregates. Export is not available for visuals using model or report measures.

  • 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. To do this:

    1. Open Excel
    2. From the Data tab, select Get external data > From text.
  • zeuslyone's avatar
    zeuslyone
    Frequent Visitor
    9 years ago

    Hello Eno1978,

     

    Thanks for the info. As far as I can tell none of these apply, but this is great clarification.

     

    Zeuslyone