Forum Discussion
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!
- Anonymous7 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
- v-lili6-msftCommunity Support
hi, Anonymous
Since it only happens to one of my workspaces.
Please check if there is Build permission problem for the data set.
Best Regards,
Lin
- AnonymousNot 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!