Power Bi Push not visible in reports

[rhh]

Hi

I have a dataset created in Power BI for pushing data to it.

The dataset has the folowing structure :

[

{

"Timestamp" :"2017-04-24T19:06:33.509Z",

"Name" :"AAAAA555555",

"Tx" :98.6,

"Rx" :98.6

}

]

Pushing data to it from a console application works fine when I add a tile with a bar diagram on the desctop.

BUT when I try to get the same dataset to work in a repport to a visual in a repport ( bar diagram also here ), nothing shows up.

What am I missing ?

Regards

[Phil_Seamark]

Have you turn on the Historical feature on the dataset? And make sure you press refresh on the menu bar.

[rhh]

Thank you for the feedback.

I missed the fact that I had to turn on the historical data.

But, the report is not automatically updated in the same way as the dashboard is. I have to press the refresh button. No way to get the report automatically update ?

[Phil_Seamark]

Hi @rhh,

No the report page isn't as dynamic as the dashboard.  Not sure why but I guess the more data you get into your model the less it may matter.

[rhh]

Hi

Thanks.

1.

So I 'works' on reports, but if I filter on timestamp (Top N, number distinct nothing shows on the report). I need to filter out the last 2 minutes. How can I do this ?

2.

And in the case of the line diagram on the desctop. It still does not work on the descop even with historical data turned on, what am I missing here ?

Regards

[v-qiuyu-msft]

Hi @rhh,

1. So I 'works' on reports, but if I filter on timestamp (Top N, number distinct nothing shows on the report). I need to filter out the last 2 minutes. How can I do this ?

We are not able to use TOP N filter to list last 2 minutes data. As it's on Power BI service, we almost can't do any data modeling. In this scenario, I'm afraid the requirement can't be achieved. 

2. And in the case of the line diagram on the desctop. It still does not work on the descop even with historical data turned on, what am I missing here ?

After enable Historic data analysis option, you need to push data into the stream dataset, then when you go to create a report, you will find there are data display in the report.

Best Regards,
Qiuyun Yu

[rhh]

This is the data I am pusshing :

[{ "Timestamp": "2017-04-27T11:30:13.056+2", "Name":"DATA","Tx":1,"Rx":63 }]

The line chart has Axis = Timestamp and Values = Tx and Rx...

Nothing shows up in the chart...

What am I missing here ?

Regards

[v-qiuyu-msft]

Hi @rhh,

After push data to the dataset, can you create a report to display data use a bar chart?

Best Regards,
Qiuyun Yu

[rhh]

I do not want to use a report. I want to use a tile on the desktop without using any report. Only create a tile to my dataset connected to my streaming data...

Creating a tile with a bar diagram ( Axis = Name, Values = Rx and Tx ) it works. Creating a tile with a line diagram (Axis = Timestamp, Values = Rx and Tx ) it does not work. Both tiles connected to the same dataset.

Why ?

Regards

[rhh]

Anyone having any ideas here ?

Regards

[rhh · Accepted solution]

Solved it. The timestamp has to be in unix format.

[rhh]

Hi

I want to.make a tile on my desctop. Not an report.

On a report it Works, on a line diagram tile not.

Thats my problem...

Regards

[rhh]

Hi

So I can't use a report but must use desktop.

I do push data data into the dataset every 5 second. The line diagram on the desctop connected to this dataset. The same dataset works fine using bars, but line diagram do not work.

What am I missing ?

Regards

[rhh]

Hi

I have a dataset created in Power BI for pushing data to it.

The dataset has the folowing structure :

[

{

"Timestamp" :"2017-04-24T19:06:33.509Z",

"Name" :"AAAAA555555",

"Tx" :98.6,

"Rx" :98.6

}

]

Pushing data to it from a console application works fine when I add a tile with a bar diagram on the desctop.

BUT when I try with a line diagram and the Axis is set to the timestamp column nothing shows.

What am I missing ?

Regards