Re: Failed to recover unsaved dataflow after error...

Anonymous · ‎05-07-2021

Many times during last years I experienced the same issue when I'm importing PQ from PVI Desktop into DataFlow:

1. Copy PQ from PBI desktop->Paste PQ into DataFlow

2. Give neccessary credentials, do visual check whether data is loaded, no errors in lines, etc

3. Click Save and validate

4. Got error when saving dataflow: "One or more entities reference a dynamic data source"

5. Say Ok, click back with intention to fix this

6. Got never ending loading screen of data flow.

I agree that I can have bad logic in PQ - no questions on this. But from the step 6 I can't get back to my queries - PB Service gives me two options - see that loading circle or reset all I've done till last save and start from the scratch.

P.S. I found an option how to recover my unsaved changes through Chrome Dev.Tools, but I beleive that's not default path.

Anonymous · ‎05-13-2021

Hi Liu Yang,

Thank you for advise, mostly I already read mentioned articles and some others related to this topic.

However, the problem statement is a bit different. My pain starts on the step 4 and later from the original post.

1. When I create new data flow and before I click "save" I never know are queries fine about dynamic sources - that's not always obiously. Moreover, during code writing I see data preview for each my query, which complex this even more and there are no error notifications or things like that - everthing looks perfectly.

2. And here the problem: After I click "Save" and get that message "One or more entities reference a dynamic data source" , I can't restore unsaved progress - step 6 is a dead end here. As I mentioned, I caught this issue at first time more that a year ago and it is still here, I can reproduce it on any my device.