BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
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.
- Changes introduced in the October 2018 Power BI update
- Changes to the DAX editor
- Filters are now searchable
- Explaining why an increase or decrease has happened
- Controlling exporting of data (this blog)
- The Web by Example connector
- Other changes in the October 2018 update
- 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:
The option to export a visual's data.
This is what you then see:
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:
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:
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.
- Changes introduced in the October 2018 Power BI update
- Changes to the DAX editor
- Filters are now searchable
- Explaining why an increase or decrease has happened
- Controlling exporting of data (this blog)
- The Web by Example connector
- Other changes in the October 2018 update
- Features awaiting in preview as of October 2018