Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Error Refershing Data Flow after move to Premium Capacity not possible

Hi All,    Since I moved our data flows to premium capacity I get the following error for some of the Data Flow Tables where others work. "Operation is not valid due to the current state of the ob...
dataflow
Need Help
v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Does this issue occur to only a specific dataflow, or all of your dataflows?

You could copy the code and run it in desktop with query editor. Check if it will show some issues.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-eachen-msft,

     

    It happens with different Data Flows - when I move the very same data flow that is in an "Invalid state" to a non premium capacity it works without an issue refresh and connecting to it. 

    When I move them to PowerBI Desktiop it works it only fails on the Premium Capacity.

     

    The stranges thing is that before the refresh on the Prem Capacity stops it even loads rows - it looks like the connection to the DF would time out before it has enough time to load. 

     

    Is there any setting that governs this on workspaces?