Refresh report visuals on a streaming dataset

[webportal]

Hi,

We've built a streaming dataset and dashboard, that works nicely to display realtime analytics.

However, the available dashboard visuals are quite limited (line and bar charts, cards only)...

So, we've also created a report, with more visuals, like maps and included some measures to enrich the analysis - connected to the streaming dataset via direct query.

It seems the only way to update those visuals is by manually clicking on the refresh button on the top corner of the report.

Is there a workaround to have the visuals automatically refreshed?

Thanks!

[webportal]

@Brunner_BI 

Thanks for helping.

I'm on a trial capacity with the following settings:

But, on the page report settings, I get only 30 minutes refreshes:

Also, when "Change detection" is enabled:

Do you know why this happens?

Thanks!

[Brunner_BI]

How does the configuration of the incremental refresh look? (in the report/dataset)

Generally, I would expect the admin settings to work but maybe something else is going on

[webportal]

Sorry, incremental refresh?

This is a Direct Query dataset connected to a streaming.

I don't see the option for incremental refresh.

[Brunner_BI]

Sorry, yes you are right. Can you share what you see for automatic page refresh in Power BI Desktop?

[webportal]

This is what I see in Power BI Desktop:

It does not allow for selection of "seconds" and the "Change detection" option is greyed out:

[Brunner_BI]

Hmm ok, sorry I really don't know... I also could not find the data sources that support DirectQuery anymore, they changed that in the docs?!

[Brunner_BI]

In DirectQuery you can set an automatic page refresh. This can only be done once you publish the report in the service and then set it in the settings of the page itself.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh