CODEWITHSUNDEEP
rpowerbipowerbi-datasource
Hackerds
Hackerds

Reputation: 1205

Power BI: Real time (date/time data) does not get refreshed on creating a report

I am streaming real time tweets using R script and sending it to Power BI using (Streaming data and REST API) to create a live streaming dashboard.

I have to create a tile which shows tweets over time. But the date/time field does not get reflected in the tile, it is just empty.

I'm not sure if I have to change the datatype or format of the field? Below is how the date/time field looks in R.

enter image description here

The streaming dataset is as below: enter image description here

Below is the tile I created (Shows blank)

enter image description here

Upvotes: 0

Views: 925

Answers (1)

Andrey Nikolov
Andrey Nikolov

Reputation: 13460

If you don't see anything in the tile, probably your dataset doesn't received anything. Try to post some data manually, e.g. from a PowerShell script (place the correct URL):

$endpoint = "https://api.powerbi.com.com/beta/........."
$Time_Stamp = ($Time_Stamp = Get-Date).Datetime
$payload = @{ "date" = $Time_Stamp; "count" = 98.6; "score" = 98.6 }
Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json @($payload))

Does anything shows up in the tile? As we see from your screenshot, you enabled Historic data analysis. This means that you can create reports with this dataset. Try to make one to show the contents in a table. Is there any rows in this dataset?

UPDATE: Actually, to be sure, copy the sample PowerShell code to post to your dataset and try it. Go to the list of datasets in your workspace, find your one in the list and click on the (i) icon. Then from API Info panel go to PowerShell and copy/paste the code in PowerShell ISE to execute it:

enter image description here

Also, keep in mind that the tile will auto update itself only in a dashboard. You may need to refresh the report to get the up to date data, if you are looking at the tile in a report.

Upvotes: 0

Related Questions