Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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!
hi, @darentengdrake
Since it only happens to one of my workspaces.
Please check if there is Build permission problem for the data set.
Best Regards,
Lin
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.