How to export directly and solely as Excel .xls da...

Anonymous · ‎05-03-2016

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 sometimes not, there is a way to set up or fix it?

austinsense · ‎05-09-2016

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

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂

Anonymous · ‎05-10-2016

@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?