This article explains Power BI Streaming Datasets as they are setup in Business Central.
1. DEMO Dataset
When the Snap! Real-Time Power BI Streaming Extension is installed, a DEMO Streaming Dataset is created so you can see some examples of how the product can be setup.
With the DEMO line selected, choose Streaming Dataset Values. The following screen shows all the associated Streaming Dataset Values for the DEMO Dataset.
Each Dataset value row can be one of the following:
- The result of a function
- The result of a row formula
- A fixed value
You can use the + New button in Business Central to add your own Streaming Datasets.
2. Populate Values
You can manually select Populate Values and the Value column will be filled for each line. Note that this action eventually becomes part of an automated routine.
3. Preview Payload
You can manually select Preview Payload. This will display a box that is for information only and shows the value names and values in the same json format that will be sent to the Power BI Service. An example is shown as follows:
4. Push URL
Later on in the setup process, and once the Streaming Dataset has been created in the Power BI service, an automatically generated Push URL is made available from the Power BI Service.
The Push URL can be copied and pasted into Push URL box against the associated Streaming Dataset Value as shown below.
You can use the Test Push button to send the dataset values to Power BI manually. An Update Successful box will confirm that the Streaming Dataset in the Power BI Service has received the data correctly.
If you have any issues with receiving an Update Successful confirmation, then check the list of Dataset values in Business Central against Power BI, check the data types are set correctly in Power BI, and also ensure that you have included the additional 3 mandatory fields as described here
5. Business Central Job Queue
Once a Streaming Dataset has been provided with a Push URL value from the Power BI Service, a Job Queue Entry specific to that dataset is created automatically.
The job queue is responsible for triggering the process that recalculates the dataset values and sends the data to the Power BI Service.
The default interval is 1 minute for each new Dataset, but this can be configured to a different number of minutes as required. Simply changing the Job Queue minutes on the Streaming Datasets Page will automatically adjust the associated job queue entry.
The Job Queue button gives you quick access to the associated Job Queue in Business Central. From here, you can also check the status and the previous Job Queue Log Entries.