Export Underlying Data not working

[darentengdrake]

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!

[v-lili6-msft]

hi, @darentengdrake 

Since it only happens to one of my workspaces.

Please check if there is Build permission problem for the data set.

https://docs.microsoft.com/en-us/power-bi/service-datasets-build-permissions#build-permissions-for-s...

Best Regards,

Lin

[darentengdrake · Accepted solution]

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!