Solved: Re: Export Underlying Data not working

Anonymous · ‎07-01-2019

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 · ‎07-02-2019

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!

View solution in original post

v-lili6-msft · ‎07-02-2019

hi, @Anonymous

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-shared-datasets

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎07-02-2019

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!