cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mikeelindsay Frequent Visitor
Frequent Visitor

Only displaying most recent data in a push dataset

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Only displaying most recent data in a push dataset

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
mikeelindsay Frequent Visitor
Frequent Visitor

Showing only newest data in dashboard for a push dataset

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?

 

Community Support Team
Community Support Team

Re: Only displaying most recent data in a push dataset

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

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