Cannot edit or create dataflow - endless spinning

[lesliewelch]

I am on government cloud - Premium Gen2. For at least a week every time I try to either edit an existing dataflow or create a new one, it just spins. On create, I spinning starts on the second screen after I select set up new tables. This has been happening at least 50% of the time since March, but I can't get it to ever open in the last week or so. Existing dataflows are still refreshing. 

I have tried Edge, Chrome, and Explorer. I have tried logging out, clearing the cache, and closing the browser before re-opening. Any other suggestions?

[m13eam]

I experience the same (Pro workspace). The dataflow refreshes work fine, but creating or editing a dataflow is a pain - just experience a "waiting" icon that spins endlessly. The only solution I've found is to go back to the workspace and try again. Eventually I'm able to get through to Power Query! I'd be very interested if anyone has found a more elegant solution.

There's hope that this issue may be resolved next week: https://community.powerbi.com/t5/Issues/Dataflows-Just-spinning/idi-p/2893118

[collinq]

Hi @lesliewelch ,

Have you seen this notice on the Power BI Support Page?

Power BI customers using dataflows may experience long running refreshes or refreshes stuck in cancelling state. As a workaround, please refer to the Power BI Dataflow known issues documentation. Engineers have identified multiple root causes and deployed first improvement of experience. A next major wave of fixes is expected to be deployed by end-of-day 07/21/2022.

I am wondering if that is the issue?

[lesliewelch]

Thanks for responding - I have seen that. In this case it is not the refresh. I can't even create a table in the first place - as soon as I click on Define new tables or Link tables from other dataflows I am immediately stuck in the spinning loading circle. Same thing happens if I go to edit an existing flow. I can refresh with no issue. 

[collinq]

Hi @lesliewelch,

I took a vacation (without technology) and am back now and am interested if this is resolved for you or if it still an issue?

[lesliewelch]

Turned out to be a VPN issue. We have to be on the vpn to log in, off to create a new flow, and back on to connect to data. My understanding is that this gets addressed internally, then microsoft puts out a new update, then it resurfaces. 

[Anonymous]

Hi I have the same issue.. the waiting time to edit a dataflow is infinite.. the refresh works fine. Just change the code is very long.. why?

[collinq]

Hey @Anonymous ,

Well, according to the Support statement "As of 07/25/2022, Power BI premium customers using Dataflows will have a more reliable experience running dataflow refreshes. For customers who are still experiencing long running refreshes or refreshes stuck in cancelling state we recommend splitting complex dataflows, limiting the total number of queries per dataflow, and strategically planning scheduled refreshes on premium capacities. On 09/29/2022 we brought another wave of improvements into production, and we are continuing to invest in further improvements. Expect more information from us by 11/01/2022. Please refer to the Power BI Dataflow known issues documentation for more details and suggested next steps."

So, I guess that based on that the options are to wait another month, break down your dataflow or create a ticket and see if there is something that Microsoft can help you with in the meantime.