topic Re: Only displaying most recent data in a push dataset in Developer

Only displaying most recent data in a push dataset

mikeelindsay — Thu, 17 May 2018 19:10:49 GMT

We're currently trialing Power Bi as a replacement for Grafana dashboards and an internal reporting system so we can consolidate them into the same system but we've hit a road block.

We'd like to be able to look back on our dashboard datasets at any given time in the past and be able to see what was going on at that moment. Grafana seemlessly updates the data since it just reaches out and queries it's data source\SQL Server and replaces the data. We've created a service in powershell that post data via api to a 'push' dataset.

I'm about to push data and get it to display however I'm having an issue filtering only the newest data to show on the Dashboard as it seems to sum everything. I've found I can clear the dataset and it shows the table with just the newest data however that causes the dashboard to go blank for that tile and flicker for a second. I've included the simple example below that I'm trying to push with the datatypes-

ServerName: String

ServerValue: Int64

RequestDateTime: DateTime

Post request looks like

{"rows": [

{ "ServerName": "server1", "ServerValue": "523", "RequestDateTime": "CurrentDateTimeHere"},

{ "ServerName": "server2", "ServerValue": "123", "RequestDateTime": "CurrentDateTimeHere"},

{ "ServerName": "server3", "ServerValue": "963", "RequestDateTime": "CurrentDateTimeHere"}

]}

All the RequestDateTime's are the same each post as they are pulled from a predefined variable prior to each request so the newest data always has the same DateTime value and I'd very much like to be able to only show whatever rows have the Max DateTime in the table.

I've been spinning my wheels on this for the past 3-4 hours. Does anyone have any suggestions?

Showing only newest data in dashboard for a push dataset

mikeelindsay — Thu, 17 May 2018 19:12:31 GMT

We're currently trialing Power Bi as a replacement for Grafana dashboards and an internal reporting system so we can consolidate them into the same system but we've hit a road block.

ServerName: String

ServerValue: Int64

RequestDateTime: DateTime

Post request looks like

{"rows": [

{ "ServerName": "server1", "ServerValue": "523", "RequestDateTime": "CurrentDateTimeHere"},

{ "ServerName": "server2", "ServerValue": "123", "RequestDateTime": "CurrentDateTimeHere"},

{ "ServerName": "server3", "ServerValue": "963", "RequestDateTime": "CurrentDateTimeHere"}

]}

I've been spinning my wheels on this for the past 3-4 hours. Does anyone have any suggestions?

Re: Only displaying most recent data in a push dataset

v-jiascu-msft — Mon, 21 May 2018 14:15:52 GMT

Hi @mikeelindsay,

Streaming data is pushed into the streaming dataset directly. I'm afraid it's hard to filter the max value. Actually, we can't filter the push dataset. Please refer to power-bi/service-real-time-streaming#can-i-use-filters-on-push-dataset-how-about-streaming-dataset. The workaround could be filtering the data before pushing them into Power BI.

Best Regards,

Dale