Forum Discussion
Exporting underlying data to Excel only returns one aggregated number
For anyone else who has this problem, the issue was I'd moved my measures from different tables in the model to a measures table
Given exporting underlying data pulls all the raw data fields in the table that the measure is in, putting measures into a measures table meant that there actually were no raw data fields
Left my end-users (and me) confused but clearer now!
Appreciate the reply! Also have really valued your articles - super helpful
I think there's something else going on with this dataset as
a) with an older version of it (prior to some recent development), I could export more than just 1 aggregated number from a table
b) when I follow the article to open the dataset in Excel, I get an error
I have no idea why it says there's a permission error. I created and published the dataset, so the admin owner of it in Service. In Excel I can open other datasets while this one has an error.
It has row level security in it, but I can open another dataset with RLS so that's not the issue.
There must be a setting somewhere that's tripping me up...
For anyone else who has this problem, the issue was I'd moved my measures from different tables in the model to a measures table
Given exporting underlying data pulls all the raw data fields in the table that the measure is in, putting measures into a measures table meant that there actually were no raw data fields
Left my end-users (and me) confused but clearer now!