Example

In this example, we want to send three numeric values originating from an OPC UA Server to Microsoft Power BI. For this purpose, we create a topic “Signals” for the OPC UA Connector and place the relevant tags “Sine1”, “Ramp1” and “Random1” into the “Signals” topic. Take note of the tag names as they are needed to configure a corresponding streaming dataset in Microsoft Power BI.

Review the topic’s read rate. If data changes quickly then data will be updated in Power BI at this rate. The update rate must not be too high so that each dataset update can be processed without accumulating many pending updates.

../_images/powerbi-task-opcua-tags.png

Sign in to Microsoft Power BI to configure a corresponding streaming dataset. If you do not have a Microsoft Power BI account then follow the steps to create a free account.

../_images/powerbi-task-powerbi-signin.png

After signing in (see image below), locate “My workspace” (1), then drop down “New” (2) and select “Streaming dataset” (3) from the menu.

../_images/powerbi-task-powerbi-workspace.png

Select “API” for the new streaming dataset and click “Next”:

../_images/powerbi-task-powerbi-selectapi.png

In this example, we will use the “sample_datetime” timestamp that is provided by the Power BI Connector. Add “sample_datetime” as a “DateTime” value. Add other values as “Number” values, with names corresponding to the configured tag names originating from the OPC UA Server. The streaming dataset configuration should look like this:

../_images/powerbi-task-powerbi-dataset.png

Click on “Create” to create the streaming dataset. Take note of the provided “Push URL” and click “Done”:

../_images/powerbi-task-powerbi-pushurl.png

Add a topic in the Power BI Connector referencing the provided “Push URL”. In this example, we name the topic “SignalsDataset” but any other name will work as well.

../_images/powerbi-task-signalsdataset.png

Add a task to Dataristix to send data to Power BI. Add the “Signals” OPC UA Connector topic and the Power BI Connector’s “SignalsDataset” topic to the task builder panel, then connect the topics. Connect the “Signals” topic connector to the “SignalsDataset”* topic connector (1) to generate tag connections (2).

../_images/powerbi-task-example1.png

Start the task to begin sending data to Power BI. You should now see live values displayed within the topic, provided that “Live Values” are enabled in the main application’s “View” menu. If no live values are shown then inspect the message log to investigate possible causes.

../_images/powerbi-task-livedataset.png

You can now begin adding dashboards and visuals to your Microsoft Power BI workspace. For example, in “My workspace”, select “New”, then “Dashboard” to create a new “Signals Dashboard”.

../_images/powerbi-task-powerbi-dashboard.png

After the new dashboard is created, select “Edit” and “Add Tile” to add a visual representation of the “Signals” data. Select “Custom Streaming Data” from the list of the available options, then click “Next”.

../_images/powerbi-task-powerbi-addtile.png

Select the “Signals” data set created earlier from the available datasets and click “Next”.

../_images/powerbi-task-powerbi-adddataset.png

Select a visualization type and select fields to display from the drop down.

../_images/powerbi-task-powerbi-addcard.png

For charts where a timestamp is required, select “sample_datetime” as the axis value and add other values as required.

../_images/powerbi-task-powerbi-addlinechart.png

Note

In our experience live updates for charts do not immediately become visible in Power BI dashboards if multiple values are added to the chart at the time when the chart is created. Either create the chart first for display of a single value and then modify the task in a second step to add other values or logout of Power BI and sign in again after creating a chart displaying multiple values.

You should now see your dashboard updating in Power BI.

../_images/powerbi-task-powerbi-visuals.png