cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
v-jiascu-msft Super Contributor
Super Contributor

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?

 

v-jiascu-msft Super Contributor
Super Contributor

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.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 195 members 2,459 guests
Please welcome our newest community members: