Which options can be used to export data as a CSV file?
→ From the Data Source page: On the Data Source page, select Data > Export Data to CSV to export all the data in your data source to .csv file.
→ From the view: On the sheet tab, drag a field to the Columns or Rows shelf, click the View Data icon in the Data pane, and click the Export All button.
While file types preserve connection properties such as file locations and database server addresses?
→ tds, tdsx(zip file)