WaterSight - Digital Twin Setup

Product(s): WaterSight
Version(s): 10.00.
Area: Documentation


The admin user can reach this page by clicking in the Administration tab. This is the page where the user can edit the existent information of a Digital Twin (DT) or incorporate new information to the DT. 

A Digital Twin corresponds to the digital representation of the physical assets, processes, or systems, as well as the information that allows to understand and model its performance. The digital twin is continuously synchronized from multiple sources, to represent its near real-time status, working condition or position. In WaterSight, each Digital Twin intends to represent a whole water supply system, including all its components and information: pipes, valves, sensors, pumps, pumping stations, tanks, reservoirs, zones (or DMAs) and customers. To know more about managing Digital Twins in WaterSight (to select one from those available, create a new one, etc) please go to the Digital Twins page. To go to the list of available Digital Twins, click in the back button located in the upper left corner of the page.

General Information

Upload image: upload an image to the DT by clicking in the blue icon button. 

Digital Twin Name: insert a name for the DT. 

Description: enter some description for the DT.

Digital Twin Features: for now the DT features available are only those related with the Water Supply system, but in the future other features will be available related with Capital Planning, Urban Drainage, Ports, Irrigation or Flood Early Warning Systems. 

Connected Project: click in the below link to manage the project and to add/delete users that have access to the DT and also to set their permissions. To know more details about this, go to the Connected Project details page. 

Team Members: View all users that have access to the DT. It is also possible to add new users directly from here, by clicking in the "plus" button, that will redirect the user to the Project Team Management page, which can also be accessed through the Connected Project page. 

On-Premise ToolsIt shows the status of the tools that are installed on premise and collecting and pushing sensors data directly from the data sources into WaterSight. If two green check marks are shown, it means that the On-Premise tools are successfully collecting and pushing sensors data into WaterSight. In case there are some problems with the data collection and transfer, a red icon will appear. Click here to know more about the On-Premise tools.


This is where all information belonging to a DT is added or edited.

WaterSight is prepared to work by modules. This means that the water utility does not need to have all the specified data in order to start using the software (minimum requirement is to have SCADA or other telemetry data). WaterSight can start to be configured based on the information currently available at the water utility. As new information is available it should then be added into WaterSight.

 Information to be configured includes:

Home button  

Click in the Home button   to force a manual and immediate refresh of the indicators and values that are shown in the home screen dashboard. Those values are being automatically calculated in a hourly routine, however the user may want to trigger immediate update of the values while he is doing changes or updates to the digital twin (for example adding new sensors or pumps, etc)

Download Configuration Template and Monthly Billing Template

Allows to download the two xlsx templates that can be used to automatically import data from an excel file into WaterSight. The Configuration template excel file can be filled and directly used to import sensors data, pumps and tanks data and customer meters characteristics. The Monthly Billing template excel file can be filled and directly used to import the billing data.

Download Power BI Connector

The OpenFlowsConnector can also be downloaded from this page. This custom Power BI connector can be installed to Power BI Desktop and an On-Premises Data Gateway to add WaterSight data to Power BI.

To get WaterSight data to your Power BI Desktop, please follow the steps below:

  • Install Power BI Desktop
  • Download the Power BI Connector from the "download" button seen in the upper-right corner of the Digital Twin Setup page and put it under the folder Documents\Power BI Desktop\Custom Connectors, on your computer. If the folder doesn't exist, please create it.
  • Open Power BI Desktop. Go to File >> Options and settings >> Options >> Security >> On Data Extensions, make sure you have the option "Allow any extension to load without validation or warning" enabled. You may need to close and reopen the Power BI Desktop again so that changes are reflected. 


  • Open Power BI again. Please go to Home tab >> Get Data >> More. Search for the OpenFlows Connector, and then click Connect.


  • Choose your Digital Twin and then the data you want to load in Power BI desktop, by clicking with the right button of the mouse and then clicking Load. 


More info on desktop installation and how to get data to your PowerBI report, please see this link.  

Note: To use the connector on the web version of Power BI, you will need to run an On-Premises Data Gateway. You can find the standard installation here https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install#download-and-install-a-standard-gateway. Please use the standard installation, running a gateway in Personal Mode is not currently supported. To install and use the connector, see https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-custom-connectors and https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh#gateway-connection. More information on gateways can be found here https://docs.microsoft.com/en-us/data-integration/gateway/.

For more information about WaterSight, please go to OpenFlows WaterSight TechNotes and FAQ's.