Forum Discussion
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 sometimes not, there is a way to set up or fix it?
2 Replies
- austinsense
Impactful Individual
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
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?
