Forum Discussion
constant refresh dataset
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.
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.