How to create date based card on dashboard using Streaming Dataset

[Josh_BI_UK]

Hi PWRBI family,

I created a Power BI dashboard that's using data coming from an Azure's Stream Analytics job. The use case is simply a stream of stock market buys and (i.e. number of trades) and total price paid for all trades within a Hopping Window.

I wanted to add a tile which references the max date of a date-time column within the dataset.

I can't seem to achieve this, any clues?

Steps I have followed are below.

Example Stream Analytics job output query used with the stream:

SELECT
    sum(Trade.Quantity * Trade.Price) as TotalTradedAmount
    , count(*) as TotalTradeCount
    , System.Timestamp as WindowDateTime
    , Max(System.Timestamp) as LastRefreshed

Example of my end dashboard:

I would like to add a Last refreshed card which shows the max date of place trades, similar to card “A” below.

A) Example of my end dashboard minus "Last refreshed card"

The stream comes through ok via the dataset (see image labelled: B) on Power BI service.

B) Screenshot of Power BI - Data set field definition

However, when I [Add a new tile], select [Custom Streaming Data] (see image labelled: C), select the card visual and try to select the [LastRefreshed] data point, it doesn't appear within the available [Fields] dropdown (see image labelled: D)

C) Screenshot of Custom Streaming Data card usedD) Screenshot showing available fields options within Tile > Card dropdown field

[Josh_BI_UK]

Hi @v-kelly-msft , I will give all your troubleshooting steps a try and reply back if any work or vice-versa. Either way I’ll do a bit of work on it and let you know asap. Thank you thus far.

[v-kelly-msft]

Hi  @Josh_BI_UK ,

Is your issue solved now?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[v-kelly-msft · Accepted solution]

Hi @Josh_BI_UK ,

Here's a checklist you can use to troubleshoot the issue:

1. Restart the Azure Stream Analytics job (jobs created before the streaming GA release will require a restart)
2. Try reauthorizing your Power BI connection in Azure Stream Analytics
3. Which workspace did you specify in the Azure Stream Analytics output? In the Power BI service, are you checking in that (same) workspace?
4. Does the Azure Stream Analytics query explicitly output to the Power BI output? (using the INTO keyword)
5. Does the Azure Stream Analytics job have data flowing through it? The dataset is only created when data is being transmitted.
6. Can you look into the Azure Stream Analytics logs to see if there are any warnings or errors?

Here is the link:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!