WiseOwl Training - Established 1992
COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.32 out of 10, based on 8936 reviews
If you found this blog useful and you’d like to say thanks you can click here to make a contribution. Thanks for looking at our blogs!

BLOGS BY TOPIC

BLOGS BY AUTHOR

BLOGS BY YEAR

A summary of the new features in the October 2018 update of Power BI Desktop
Part five of an eight-part series of blogs

Not an earth-shaking update, but lots of nice new features nonetheless to make your life easier, including a better DAX editor, the ability to search for text when filtering a visual and a clever new connector which guesses what you want to import from a website.

  1. Changes introduced in the October 2018 Power BI update
  2. Changes to the DAX editor
  3. Filters are now searchable
  4. Explaining why an increase or decrease has happened
  5. Controlling exporting of data (this blog)
  6. The Web by Example connector
  7. Other changes in the October 2018 update
  8. Features awaiting in preview as of October 2018

For a cumulative list of all of the updates to Power BI Desktop in the last few year or two, see this blog, or have a look at the Power BI courses that we run.

Posted by Andy Brown on 19 October 2018

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Controlling exporting of data

When you publish a report to Power BI Service, you can then export its data:

Exporting data

The option to export a visual's data.

This is what you then see:

Export data options

By default in the new Power BI you can only export data at the level at which it appears in a visual.

This is what this produces:

Exported data in Excel

I'd applied a filter by year to my chart, which Excel is showing in cell A1. There are thousands of purchases in my model, but all I can see is the aggregated data.

 

As well as changing the default export option for published reports, Microsoft have also given you the opportunity to change this in Power BI Desktop:

Power BI options

You can change the settings for how a user can export data in Power BI options.

You can also change this through the Report Settings pane in Power BI Service.

  1. Changes introduced in the October 2018 Power BI update
  2. Changes to the DAX editor
  3. Filters are now searchable
  4. Explaining why an increase or decrease has happened
  5. Controlling exporting of data (this blog)
  6. The Web by Example connector
  7. Other changes in the October 2018 update
  8. Features awaiting in preview as of October 2018
This blog has 0 threads Add post