Dataflow with Machine Learning model attached will not refresh

[motoray]

Hello all,

I started working with the Machine Learning models for dataflows last month. After setting them up succesfully, I had to step away for a while. Now when I try to set up a new one following the same steps, I get the error: "Error: On-Prem execution not supported for entity..." and the refresh fails. I still have one of my original models and it continues to refresh fine. Doing a stare and compare between the two dataflows doesn't reveal anything. I've tested using the same data source (on-prem SQL server), using a different (new) premium workspace and many other combinations and they all lead to the same error. I'm working with my Office 365 admin to try to submit a ticket, but haven't been able to do that either. Anyone else run into this?

Thanks in advance,

Ray

[v-yalanwu-msft]

Hi, @motoray ;

In this case you could try to untick the Enable load option on the linked entity. and refer to the following article.

https://radacad.com/workaround-for-computed-entity-in-power-bi-pro-dataflow-in-power-bi

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-premium-features

https://community.powerbi.com/t5/Service/Dataflows-Error-On-Prem-execution-not-supported-for-entity/...

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[motoray]

Also worth noting--attempting to change any of the queries once the model is applied means they will no longer validate properly...and can't be saved.

[motoray]

I have the new dataflow set up exactly the same way as the old data flow. Loading the same entities--and not loading the others.