cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with Query validation in Dataflows

I began experiencing an issue with dataflows where I am no longer able to save queries, I get the validating message for more than 3 hours and it doesn't crash or advance. Previously it was taking about 3 minutes.

image.png

 

I already tried running a similar query in the desktop app and it runs really fast so I don't think it's the complexity of the query (also it was working fine last week)

 

Has anyone encountered this issue before?

 

Status: New
Comments
Frequent Visitor

Have the same problem but these are new queries. Just going to follow this conversation.

Community Support

Hi all, 

 

Please test again. If the issue still occurs, I would suggest you create a support ticket to get help. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu

Advocate I

So the only solution I found was leaving it overnight and it evenutally finishes 😕

Regular Visitor

We are still having issues with this.  For our Use Case, we just needed to switch the underlying source from Sharepoint Online folder to a Gateway folder entry.  Change was super straight forward, but when we tried to save, the validating queries never returned (think it actually times out after 24 hours).  

The one hack we discovered was to export the JSON, edit the necessary lines and import it back in. Then we just went to the DataFlow settings to bind the Gateway connection.  We tried editing the DataFlow afterwards to see if it still gets stuck in infinite validing queries and surely enough it did.  This is certainly a bug that Microsoft needs to look into... 

Frequent Visitor

Following thread

Frequent Visitor

Following thread