Forum Discussion

Gnanasekar's avatar
Gnanasekar
Helper III
9 years ago
Solved

Underlying data

Hi All,  1.In my report export underlying data in excel format is working. But it excluding some column in my table. That columns not a measure, it are direct column in table. why this excluding hap...
Need Help
Tips and Tricks
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Gnanasekar,

     

    Question 1: If you set the column to "Hide in Report View", then this column will be excluded when export underlying data to excel file.

     

    Question 2: I canot reproduce this issue, could please provide us some sample data and the detail steps to reproduce this issue, so that we can make further analysis.

     

    Question 3: If all column in your visual is set to "Don't Summarize", then you cannot use "Underlying Data" since all the data is un-aggregate.

     

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Gnanasekar,

 

Question 1: If you set the column to "Hide in Report View", then this column will be excluded when export underlying data to excel file.

 

Question 2: I canot reproduce this issue, could please provide us some sample data and the detail steps to reproduce this issue, so that we can make further analysis.

 

Question 3: If all column in your visual is set to "Don't Summarize", then you cannot use "Underlying Data" since all the data is un-aggregate.

 

Regards,

Charlie Liao

  • Gnanasekar's avatar
    Gnanasekar
    Helper III
    9 years ago

    Hi v-caliao-msft

     

    In report backend has 24 columns (included 5 aggregate columns(A,B,C,D,E) "default category is SUM")

    I am using B aggregate column in report. In export underlying data contained 20 columns. Only B aggregate column was present. Remaining 4 columns were excluded from underlying data in that report.

     

    Why?

    we can't get all aggregate column in underlying data without used in visual?

     

    By

    Gnanasekar