After installing the plugin on Grafana, you need to create a new datasource that points to the sqlite db file.

The dashboard however must be built to utilise sqlite queries. Just edit any of the panels and make sure it is indeed using the newly created datasource.