At the place where you have installed Helical Insight, all the files folders gets stored in "hi-repository". You can copy only selected content or all the content from "hi-repository" of your Azure instance and paste it into your local instance "hi-repository". It is always advisable that the folder structure of content from source and into target matches.

Copy paste "globalConnections.xml" file from source (azure) into your local one. Globalconnections.xml file is present in "Helical Insight\hi-repository\System\Admin" folder. In the local instance if you have already created few dbconnections that also you can manually copy and add into this global connections.xml but please make sure that each datasource in globalconnection file should have a unique id.

Open the metadata in the edit mode inside helical insight application. Once it is open in the "Info" tab point it to the correct datasource.