Export underlying data returning only totals row.
Based on my testing, I do not believe the following limitation is adequately explained.
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
I was also working with a dedicated Measures table, so in order to satisfy the requirement above I created a dummy value of 1 in my Measures table, and joined it to my Fact table which also had a dummy value of 1 for every row. My chart was using a Measure from the Measures table, which is now joined to the Data Model via a 1 to * relationship with the only Fact table.
When exporting all underlying data, I still only got a single record with the Total value for the measure. The only way I can get this to work is to move the Measure from the dedicated Measures table to the Fact table.