Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Data Flows error when validating queries

I have two dataflows that have been working for months and still refresh successfully. The issue I have is that when editing either of them now, then clicking save and close, I get an error message saying 'An error occurred whilst validating your queries' after a few minutes.  This even happens when making no changes at all to the existing data flow and just clicking 'Save and Close', suggesting that either...

  1. the validation process has changed since this was last done successfully 
  2. there is a wider problem impacting both dataflows 

I am able to see a preview of all tables before with no errors before clicking Save and Close so can't narrow it down to any issue with a particular table. This means I can't edit develop either data flow beyond their current state and seems too much of a coincedence that both are experiencing the same issue all of a sudden. 

 

The fact this error occurs so quickly seems to suggest it isn't a memory issue.

 

Has anyone experienced this issue too recently?

 

Thanks

Status: New
Comments
v-robertq-msft
Community Support

Hi,

Unfortunately, I can’t reproduce the same issue as yours.

According to my test, I can normally edit and save&close a dataflow:

vrobertqmsft_0-1633575306738.png

 

vrobertqmsft_1-1633575306740.png

 

Best Regards,

Community Support Team _Robert Qin

mz_1122
Frequent Visitor

+1 Same here. Til today I'm still facing similar issue.

1. Tried refreshing the dataflow>> no error, then open the edit window, without editing click "Save & close" then error message
2. Then tried to edit the query of the dataflow>> preview of dataflow all ok BUT once "Save & Close" clicked then start validating queries then not long after error message appears.

 

Tried numerous time still the same issue. Even tried doing the same query step by creating new dataflow. Can't proceed to "Save & Close"

Either of this 2 error message will appear no matter how many times I tried.

mz_1122_1-1638450608043.png

mz_1122_2-1638450848189.png