Power BI Machine Learning, using Data flow (via gateway) error

[Anonymous]

Hi,

I am tryng to train a model from a data flow, data flow created on top of SQL Server database using gateway, it refreshed fine on it's own, but when I add a machine learning model (binary prediction), it does not refresh and producs error.

An error happened while reading data from the provider: 'Error from AutoML: Error occurred while training AutoML Model'

any help owuld be appricated.

Thanks

[Anonymous]

I'm also having this issue. Only affecting Binary because of AI.SampleStratifiedWithHoldout function issues

[Anonymous · Accepted solution]

I had a conversation with Microsoft people working on it, you need to update the gateway to new relased version, as this is the fucntion they included in the new gateway, they also processing a new update at backend of it.

While it resolves the above issue, there is another problem,  it is not showing summary report of processed model, it tries searching for it for ages and then comes up with the message that it cannot find it...

[Anonymous]

I had the same issue and my refreshes kept failing subsequently after building a model.

I looked at the error and mine stated that the credentials were invalid. After going back into the settings of the dataflow, I re-entered the credentials which seemed to resolve the issue for now. I have noticed that AutoML within PBI has been spotty with its refreshes.

Hopefully that resolves your issue and you're able to refresh from there.

[Anonymous]

Thanks for your reply, already did that few times for no joy, below is the error we getting when trying to refresh it, in one of the training model created on top of data flow from Power BI, any help would be appreciated.

We encountered an error during evaluation. Details: The name 'AI.SampleStratifiedWithHoldout' wasn't recognized. Make sure it's spelled correctly

Thanks