question

Mary-4314 avatar image
2 Votes"
Mary-4314 asked Gerben-2422 commented

Unable to parse the response from the Azure ML Web Service - PowerBI, Azure Auto ML, Time Series

Hi everyone,

I have issues while interfacing Azure ML with PowerBI. I deployed a model from Auto ML, and tried to consume it in PowerBI. I successfully completed the following tutorials create a predictive model by using auto ML and consume a model in PowerBI . But when it comes to implement my proper model, I get this error : "Unable to parse the response from the Azure ML Web Service".

I have to add that my model forecasts time series. On the contrary, the model was a regression in the Microsoft tutorials. And I didn't use R or Python script, I used exactly the same method as the second tutorial about PowerBI.

Thank you very much for your help ! don't hesitate to ask me if you need more information.

Mary






azure-machine-learningpower-query-not-supportedazure-time-series-insights
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Mary-4314 For time series automl models that can be used for consumption with powerbi the following tutorial details the forecast settings that can be used. Could you please check and validate if you are using these settings or try this scenario with this documentation?


1 Vote 1 ·

I @romungi-MSFT yes I am using these settings. I did the whole tutorial, and I get the same error.

0 Votes 0 ·
NikhilMehta-4297 avatar image
0 Votes"
NikhilMehta-4297 answered NikhilMehta-4297 published

I am facing the exact same problem.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VinnieZhang-9089 avatar image
1 Vote"
VinnieZhang-9089 answered Gerben-2422 commented

Had the same issue myself, and I figured out that time series models in Azure AutoML only accept input datetime that's later than the latest datetime used when training. I have monthly data and I used until Sep 2020 to train my model, so when I filtered my input data in Power BI to only Oct 2020 and later, the AutoML model finally ran successfully. Hopefully this is helpful.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for your solution! I had the same issue with a TimeSeries model from Azure ML. The Regression model worked in PBI but TimeSeries returned a 'could not parse output' error. I couldn't figure out what the issue was but this worked :)

0 Votes 0 ·