Converting a report to view associated data

Hi JoeyF ,

On each of these tables, go to the format bar and make sure that Visual Header is switched on, and at least 'More options icon' is also switched on:

This will give the end user the option to click the ellipsis that appears over the table on mouse hover.

Within the ellipsis menu they will have an 'Export data' option that will allow them export summarised data (data as it appears in the table) to Excel.

To give the end users more detail, you will need to go into Options and Settings in your PBIX and enable exporting of underlying data:

ALSO you will need to give each user Build permission on your report dataset in the Service once your report is published (think carefully about this).

If you don't want to give build permission to end users, you could create a hidden page in your PBIX that just contains a table with row-level data detail straight from your source table.

On this hidden page, put the measure(s) that feature in your summary tables into the Drillthrough fields section:

This will give the users the option to carry over selected page filters onto the drillthrough page and thus see the underlying data that makes up the summaries.

Users can then export this detail table as summary data and still get all the detail in view.

Pete