Status:
Accepted
Export underlying data returning only totals row.
Hi, I checked all the settings of my report, but not able to find where I am missing. When I export the data "Underlying" excel, the only total row is being exported. Could anyone p...
v-qiuyu-msft
Community Support
Community SupportHi Anonymous,
I got the information below:
"Per the documentation: "If the visual uses data from more than one data table, and no relationship exists for those tables in the data model, only data for the first table is exported."
- https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
It seems like the customer realized that and responded in the linked thread. Please inform the customer that this is a limitation and not a bug. To export the full data, they need to create a relationship between all the tables used in the visual."
Best Regards,
Qiuyun Yu