Engineering Dashboard - Views - Exporting data to Microsoft Excel file format - Missing Data

This page helps to troubleshoot issues when the Downloaded Data is missing from the Excel file file but is present on the view

Step by Step scenario

1. Open ED
2. Navigate to a view
3. Export data to Microsoft Excel file format
4. Open the Downloaded Excel file

Perform the below actions

1. Activate SQL Traces by following the page Health Dashboard - Information - How to activate SQL traces on AAD and RestAPI logs, then Identify the query involved in the display of the view and the query involved in the Export data to Microsoft Excel file format

2. Compare the results between the 2 queries.

   1. If the results are identical then the issue is due to the Excel file configuration, as a workaround you can export the SQL results of one of the 2 queries to a Excel file, for this refer to The Import/Export data Dialog
   2. Else if the results are not identical then the issue is due to the query retrieving the Data from the schema, as a workaround you can export the SQL results of the query involved in the display of the views to an Excel file, for that refer to The Import/Export data Dialog 
3. If the above steps do not help you, contact CAST Technical Support. with Relevant input

Ticket # Number, Number

Specify pages indirectly related to this topic.(eg:side- effects)