Streaming Dataset with Historical Analysis

[rayd_250592]

Hi,

I have a streaming dataset with historical data turned on which I understands creates a streaming dataset and push dataset.

How can I access this Push dataset via the REST API?

Thank you!

[lbendlin]

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

[rayd_250592]

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.

[lbendlin]

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?

[rayd_250592]

Based on https://community.powerbi.com/t5/Service/History-Data-Analysis-option-in-Streaming-dataset/td-p/1569..., 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.

[lbendlin]

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.

[rayd_250592]

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.

[lbendlin]

The push REST API does just that - push.

For data retrieval you need to use an XMLA client.

[rayd_250592]

Push Rest API isn't just push - see https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_gettables

[lbendlin]

You are correct.  I am able to see my data tables with that API call. 

Is your streaming dataset in your personal workspace or in a regular workspace?

[amitchandak]

@rayd_250592 , refer if this can help

https://community.powerbi.com/t5/Service/History-Data-Analysis-option-in-Streaming-dataset/td-p/1569...