Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

How to export directly and solely as Excel .xls data?

my report sde tables to be exported need to be exported already with the formatting of Excel (row and column), but with the last update of the power bi times the export goes with formatted I need and...
Need Help
austinsense's avatar
austinsense
Icon for Impactful Individual rankImpactful Individual
10 years ago

It's hard to understand exactly what you're asking for - if the question is "Can I export data to an Excel file with the timestamp of the lasst update?" then the answer is no, BUT you can hook Excel up to your PowerBI model and refresh the data.  This feature is called "Analyze in Excel" and you can find out more HERE

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    austinsense

    sorry for not have been clear to my question, but in short, because it report that the export will already formatted in columns and rows and there are others who will in csv format?

     

    And another question, sometimes in Excel after you export the data, many special characters are displayed, how can I fix this?