Azure ML time series model integration with Power BI

[mukundkalani21]

Hi,

I am trying to integrate an azure ML time series model with powerBI. I deployed the model and I can access it on PBI and if I enter a date, I get a prediction for my variable. However, I only get one prediction at a time. I want to be able to see the prediction for 30 days in the future (for example) and I also want to see the predictions the model made for the days in the past (for comparison).

I can't seem to figure out how to get a column beside my existing data that gives the predictions for past dates as well as for sometime into the future.

Does anyone have any specific experience with this or generally with integrating azure ML and PBI? Please let me know, any help is appreciated. Thanks!

[RogerWei]

Hello again,

To be specific, anybody find a good way to use Power BI to "Consume" the model trained by the Auto ML (time-series forecast), instructed in the tutorial here - https://docs.microsoft.com/en-us/azure/machine-learning/tutorial-automated-ml-forecast?  

 Many thanks!

[RogerWei]

Faced same issue with mukundkalani21, how in one-go to get the forecasts with dates in the horizon... sounds always getting an error

[amitchandak]

@mukundkalani21 ,

refer if these can help

https://docs.microsoft.com/en-us/power-bi/transform-model/service-machine-learning-integration
https://www.youtube.com/watch?v=oNwZ40Q2eAU
https://powerbi.microsoft.com/en-us/blog/tag/azure-ml/
https://powerbi.microsoft.com/en-us/blog/power-bi-azure-ml/