Question: how to open gpkg file in qgis?
Answer: Leave Source type as "File". Browse to select the GeoPackage you wish to open. ... 
This will fill in your Source Dataset . Click Open to bring up the list of layers in the GeoPackage.
Select the layers you would like to load in the map. Hold CTRL to select multiple layers.