Capturing daily counts over time

[ddownard]

I have some data counts coming from a preexisting dataset on a daily basis which are currently in a dashboard for end-users.  While it's nice to see the counts each day, I need to also have a line chart that graphs the counts for each day.  I was told this could be done with a streaming dataset but the use of Powershell, JSON, Python, etc. is outside my skillset.  

Here's a simplified example of the dataset already in use.

Record ID	Current Phase
7584	Phase 2
6548	Phase 3
159	Phase 1
1234	Phase 1

The dashboard then shows tiles for the total count of records in each phase.

The counts aren't stored data so if I was asked today what the counts were last Friday, I couldn't do that.  The next day, the dashboard will indicate different counts.  I'm looking for an automated means for the new data to be added to a line chart.  Something like what's below so that tomorrow, we'd look at our dashboard and see the current counts and historical counts for comparison.

[v-stephen-msft]

Hi @ddownard ,

Is there a date column in your main table?

If there is, it is easy to show the counts each day. Try to create the following chart.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Nothing about streaming datasets is simple. Real-time streaming in Power BI - Power BI | Microsoft Docs

How about the other option - you managing the data in your external source?

[ddownard]

The external source is a database in which I have read-only access. 

[lbendlin]

Sorry, but it's either streaming datasets, or you need to take care of the data storage at the source (outside of Power BI). Power BI has no memory.

[ddownard]

Thanks @lbendlin.  Do you have any suggestions for simplified "how-tos" on the streaming option I'm needing.  I've watched quite a few but what I've seen thus far are more technical than I'd prefer and are for data coming from the computer in-use, such as, load speeds, memory, etc.