Forum Discussion
Streaming Dataset with Historical Analysis
access it to do what? Push data in, or pull data out for historical analysis?
https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming
Pull the most recent item out was the plan but the streaming API doesn't match the format https://api.powerbi.com/v1.0/myorg/datasets/%7bdatasetId%7d/tables/%7btableName%7d/rows mentioned in the docs.
You can't do historical analysis with pure streaming datasets - they simply have no history. Your streaming dataset needs to be a hybrid (push) version .
Why would you need to pull the most recent item out? You just pushed it in so you should know what it is?
Based on https://community.powerbi.com/t5/Service/History-Data-Analysis-option-in-Streaming-dataset/td-p/156977, by enabling historical data analysis, does it not become a push data set?
I'm pushing a value from an App to the API which works fine. The idea is to pull the mist recent value down to another instance of the app.
In Power BI Desktop you can connect to your dataset (Data source Power BI Datasets).
But be aware that this is extremely inefficient as you are looking at a year's worth of data just to filter that down to the latest timestamp for information that you already have.
Push your value from the app to the other instance of the app directly.