PowerBI adapter allow you to specify if the datasource should use primary or secondary nodes. The same feature should be available for charts.