Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Export Underlying Data not working

Hi,

 

I am trying to export any visual/tables/matrices as underlying data but all I got was a super summarized version of my data. I have full admin rights and this only happens to one of my workspaces, some visuals of the same report exports underlying data and some don't. Any idea what's going on?

 

Thanks!

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi v-lili6-msft ,

     

    I found out what the problem was. My visuals are created with measures as values and a few fields. It seems that the measures cannot be in it's own "Home Table" and had to be assigned to tables that I imported/created and not a "Measure Home Table". I don't know why this poses a problem but ever since I changed the Home Table of every measure that I used to create visuals, it works when I export underlying data.

     

    Thanks!

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi v-lili6-msft ,

       

      I found out what the problem was. My visuals are created with measures as values and a few fields. It seems that the measures cannot be in it's own "Home Table" and had to be assigned to tables that I imported/created and not a "Measure Home Table". I don't know why this poses a problem but ever since I changed the Home Table of every measure that I used to create visuals, it works when I export underlying data.

       

      Thanks!