constant refresh dataset

[AI14]

Hi

im new to Powerbi and recently used a azure dataset to create a report and published it.

the database pulls data from our live operation every 5 mins and i want to know how i can live stream the updates so my report is up to date instead of having scheduled refreshes?

what apps or external apps do i need and how can i get this done - Thanks

[ibarrau · Accepted solution]

Hi. If you just want to show current refresh keeping historic analysis for another report, you can use a Streaming Dataset "Push Dataset". You can read more about that here: https://learn.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming#push-dataset

Basically you can define a table structure at Power Bi Service. It will show a URL to Post a request. Using that URL and a body covering the columns of the table you can send Post requests to add rows at any moment you want. You just need a place to run a custom script that you can write on any programing language.

I hope that helps,

P/D If it's not a lot of data and you are keeping it in a database you can try direct query reducing cache. It takes between 5 to 15 minutes.