Forum Discussion
Streaming/Push Dataset Question
when you have an import mode dataset you can choose to schedule refreshes (up to 48 per day if on premium, and up to 8 per day if not). But these schedules may not coincide with your business process events. The better option is to initiate a refresh when the source data has changed, based on some kind of trigger. Once the event happens (source data changed) you can then issue an API call to request a dataset refresh. Once the dataset is refreshed successfully your dependent dashboards will update automatically.
For dependent reports you will need to find a different solution (direct query with auto page refresh, for example)
Push datasets have that name for a reason. You can only push into the dataset. You cannot modify data that you have pushed. You cannot (at the moment) remove individual pushed rows. You can only clear out the entire dataset and start over.
Push datasets are not suitable for your scenario. Consider using a SQL Server dataset in Direct Query mode or API based regular dataset refreshes.