Overview

This article shows an example Streaming Dataset setup in Business Central and also describes the 3 additional Streaming Dataset Values that are always sent to the Power BI Service.

• 1.  Example Setup
• 2.  Additional Dataset Values

1.  Example Setup

The Snap! Real-time Power BI Streaming Extension gives you the flexibility to setup and define the Streaming Datasets and values depending on your requirements.  See below a simple example for a new Streaming Dataset that has been added with 3 values.

2.  Additional Dataset Values

Regardless of what dataset values you define in Business Central, each set of data pushed to the Power BI Service will include 3 additional values as follows:

• pushId
  • This is a numerical ID value which will increment to a higher value for each dataset pushed to the Power BI Service
  • When the value is setup in the Power BI streaming dataset, this should be defined as Text which will prevent Power BI from automatically summing up the values.
• timestamp
  • This is the UTC timestamp value for each dataset pushed to the Power BI Service
  • When the value is setup in the Power BI streaming dataset, this can be defined as DateTime or Text depending on how you want the values to be displayed in Power BI. It is recommended to set this value as DateTime.
• localtimestamp
  • This is a date time value in local timezone of the Business Central user.
  • When the value is setup in the Power BI streaming dataset, this can be defined as DateTime or Text depending on how you want the values to be displayed in Power BI. It is recommended to set this value as Text.