Forum Discussion
Streaming Dataset with Historical Analysis
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.
How can I connect to the data set via the Push REST API? I've no problems connecting via the power BI App.
By enabling historical data analysis, it should be a push dataset accessible via https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets but its not.
The push REST API does just that - push.
For data retrieval you need to use an XMLA client.
Push Rest API isn't just push - see https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_gettables