Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

AIFunctions failed on Dataflow

I try to create an ML model on Dataflows.   When I configured all settings and returned to the Power Query editor, the model failed because AI Functions could not load.   When the query is ...
Dataflow
Need Help
v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Anonymous 

 

It seems like you are having issues with your AI functions when creating an ML model on Dataflows. One of the reasons for the error message "Failed to analyze issues in the query" could be due to the AI function and gateway not being supported. Another reason could be due to the dataflow being assigned with an incorrect gateway. If you are using a gateway, you should check if the gateway is configured correctly and if it is running. If the dataflow refresh is in progress for more than 100 hours, then you should restart the gateway to stop the refresh. 

 

TSG:: Dataflow cannot acquire lock for model due to current use error - Overview (azure.com)

TSG:: Something went wrong while evaluating this query or Power query running two exact same queries - Overview (azure.com)

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi v-zhangti ,

    Can you provide a more specific way to check whether the gateway is configured correctly?

    Also, I can't access your two links.

    Thanks