cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Josh_BI_UK
Helper II
Helper II

How to create date based card on dashboard using Streaming Dataset

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"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 definitionB) 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 usedC) Screenshot of Custom Streaming Data card usedD) Screenshot showing available fields options within Tile > Card dropdown fieldD) Screenshot showing available fields options within Tile > Card dropdown field

3 REPLIES 3
Josh_BI_UK
Helper II
Helper II

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.

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
Community Support
Community Support

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!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors