Exporting underlying data to Excel only returns one aggregated number

[Anonymous]

I have a dataset that enables export of underlying data and have made a report that enables export of underlying data. The dataset has RLS on one table.

When a user exports summarized data, they get all the numbers in a simple table visual. When they export underlying data, they get a single grand total. 

Any tips on what I'm doing wrongly in the setup?

[MattAllington]

This is working as designed. Power BI is not built to export data, it is built to analyse data in Power BI. If you want to export data, you could look at my article here https://exceleratorbi.com.au/extract-tabular-data-power-bi-service-excel/

[Anonymous]

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...

[Anonymous · Accepted solution]

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!