BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
This month's update doesn't include many changes - the biggest being probably the emergence of the hierarchical slicer from preview.
- Power BI June 2020 update - summary of new features
- Hierarchical slicers
- Much-improved mobile report designer
- Individual dots on line charts
- Automatic refresh (this blog)
- AI insights in Query Editor
Posted by Andy Brown on 28 June 2020
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.
Sounds good, doesn't it? However, there's one massive caveat - this feature is only relevant if you're using Direct Query.
Direct Query means that there is no intermediate data model between your reports and your data.
Direct Query is ideally suited for situations where you have a very large amount of data which changes often (for example, transactional data from a retail store). However, Direct Query has many disadvantages, which is why it doesn't feature much in Wise Owl blogs or courses!
Setting up automatic refresh
If you've linked to a Direct Query source of data, you can set the page refresh type for any page's properties:
Make sure you don't have any visual selected on your page, then change its properties as shown here.
Automatic page refresh as shown above is fairly self-explanatory, but you can also use change detection:
Change your refresh type using the drop down list.
Once you've done this, you can add a change detector:
Click on the link shown to specify what should trigger updates.
You can then tell Power BI when it should update your data:
As an example, you could tell Power BI to refresh all of your data only when the number of purchases changes.
Obviously the above example wouldn't save much processing time, because Power BI has to go to the underlying data source at regular intervals to recalculate the value of the measure you're using for change detection.