Return
-
Title
When exporting data to csv some of the queries cannot be seen in excel -
Description
When extracting data to csv file using this command line :get-workloadanalysis -ConnectionNamesome queries are not correct in the csv and numeric data is missing.
Using Save As button also gives bad result.
It seems all queries beginning this way are badly extracted :-- =============================================-- Author: -- Create date: -- -
Cause
Problem is with Excel 2016 which is not parsing properly the files -
Resolution
Open the file with any other editor such as Notepad or Notepad ++ or with another Excel version