Direct Query Refresh Rate

[Acyrus1992]

Hi all

I have a direct query setup.

I have a Report build, that is used to pull about 50 rows of data, and display a count down clock till a Target Date is breached.

This is perfect for me.

However i need the refresh rate to be under 5 minutes.
The limitation of the system, is 15 minute refresh rate.

How can I get around this?

I cant use an API - as the Dashboard page doesnt have this functionality to display the equivilent of the Reports page.

Any suggestions would be helpful.

[Anonymous]

@Acyrus1992 The only way of achieving this would be using an API - streaming or push dataset. See here. On a streaming dataset you can use reports if you enable the "Historical Data Analysis", or use a push dataset.

[Acyrus1992]

Hi Eno1978

Thank you for the direction.

I have clicked - Historic data analysis, to On

And each time, it changes itself to Off

I am able to use the RealTimeData set now in the HTML Report Editor, to build the report correctly - however its all black at the moment with no data?

Have I missed a step somewhere?

Regards

[Anonymous · Accepted solution]

@Acyrus1992 Did you create an API and then when creating the dataset in Power BI use the "Push URL" that was generated as the API Endpoint?

[Acyrus1992]

Thank you 

That did the trick!