Power BI: Allow Export of Summarized and Underlying Data

If you're having trouble trying to export data from a Power BI report to Excel or CSV, a small tweak to the report itself might solve your problem. There is a setting that allows report authors to limit which data may be exported. Here's how to change that setting.

With your report open in Power BI Desktop, go to 'File', 'Options and settings', and then click on 'Options'.

In the left-hand side menu under 'CURRENT FILE' (not under 'GLOBAL'), click on 'Report settings'.

Now you should see a header called 'Export data'. In this section you can choose to allow end users to export summarized data, allow both summarized and underlying data, or to restrict data export altogether. Change this setting and republish your report.

Read More

SSRS: Remove Margins From Chart

 If you want to remove that extra white space from the sides of a chart in an SSRS paginated report, then you can do so by removing the margins.

With your report open in Visual Studio, select the chart axis and then open up the Properties pane. Scroll down to 'Margin' and set this property to 'False'.

Read More