Editing Dataflow error code "status code: 500"

[kadirkkkk1]

When i click edit button on a dataflow (gen1) it gives that error below. And after a while it fixes itself and i can edit dataflow. Especially today i get that error frequently. 

Activity ID: 9a2eded7-65b1-4d76-8f23-081d3112c695
Request ID: 28dbb522-b085-0edb-29cc-2241ada4d365
Correlation ID: 412a0606-bd12-55f7-0f10-b7f804aee294
Status code: 500
Time: Mon Aug 04 2025 12:47:29 GMT+0300 (GMT+03:00)
Service version: 13.0.26369.35
Client version: 2507.3.25169-train
Cluster URI: https://wabi-west-europe-g-primary-redirect.analysis.windows.net/

[rargyle]

Hi again, we're on a Pro licence, and I raised a ticket, which after some discussion and diagnostics, has been answered by Microsoft Support as follows:

"I wanted to share some insights regarding intermittent issues we've observed while editing dataflows in Power BI Pro, particularly the Error 500 accompanied by a NullReferenceException in backend traces.

As all workspaces in Power BI Pro operate on shared capacity, meaning compute and memory resources are shared across multiple tenants. When a dataflow is edited, Power BI initiates a metadata rendering session and loads the model into memory. If the shared capacity is under heavy load, these sessions can fail intermittently, resulting in the error mentioned above.

Importantly, this is not a user error but rather a backend instability. These failures are non-deterministic and can affect different dataflows at different times.

Recommended Actions:

• Avoid Editing During Peak Hours: Try scheduling edits during off-peak times to reduce the likelihood of encountering these issues.
• Retry in Incognito Mode or After a Delay: This helps clear session state and bypass cached metadata, which can sometimes cause problems.
• Consider Migrating to Gen2 Dataflows: Gen1 dataflows have known limitations in error handling and diagnostics. Gen2 offers improved performance, reliability, and better support from Microsoft.
  
   

"

I have responded asking them if Gen2 Dataflows are available under Pro licence as I'm led to believe they're only available in Fabric or Premium licences, therefore not a valid solution for us.

[rargyle]

Response from Microsoft clarifying Gen2 as follows:

"

To clarify: Gen2 Dataflows are not available in Power BI Pro alone. They are part of the Microsoft Fabric ecosystem, which offers enhanced performance, flexible storage options, and improved diagnostics. However, access to Gen2 requires a Power BI Premium Capacity (e.g., P1 or higher).

If you prefer to continue using Power BI Pro, I recommend working with Gen1 Dataflows and applying the following best practices to reduce the likelihood of errors:

• Edit during off-peak hours to avoid issues caused by shared capacity overload.
• Retry in incognito mode or after a short delay to clear session state and bypass cached metadata, which can sometimes interfere with rendering.

These steps can help mitigate intermittent issues such as Error 500 and improve your overall experience with Gen1 Dataflows.
"
So basically, no real solution, just deal with it or pay for upgrade.

🙄

[v-prasare]

Thanks @rargyle  for continues updates here. your inputs truely helps our community users resolve similar issues quickly. please do share if you still have any updates related to this issue.

[rargyle]

I replied to Microsoft Tech Support saying "thanks for your emails. I’m disappointed that I have no other real solutions. Premium/Fabric licensing is not under my remit, so I will have to continue with Pro until such time my organisation has budget for upgrade."

They replied "I wanted to reiterate that Gen2 Dataflows offer significant performance and scalability improvements over Gen1, and with Gen1 scheduled for deprecation in the near future, transitioning to Gen2 will eventually become essential. Unfortunately, Gen2 capabilities are only available under Power BI Premium or Microsoft Fabric licensing, which does limit options for Pro users at this time.

Hence, please consider moving to Dataflow Gen2 for better capabilities and performance when feasible."

I have responded asking them "At the time when Gen1 is depreciated, I’m assuming Gen2 will become available on Pro licence?"...I will update here when I get a response.

[rargyle]

Latest response from Microsoft:
"At this point, we cannot confirm details about future licensing changes once Gen1 is deprecated. As of now, Dataflow Gen2 requires Fabric capacity and is not available under the Pro license. If there are any updates regarding broader availability in the future, we’ll be sure to communicate them."

[rargyle]

I'm having the same issue this week. I'll raise a support ticket as well.

[rargyle]

I'm having the same issue this week. I'll raise a support ticket as well.

[v-prasare]

If your issue still persists, please consider raising a support ticket for further assistance.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

[kadirkkkk1]

I dont have a Fabric subscription plan to report bugs on Power BI

[v-prasare]

Hi @kadirkkkk1,

even with the pro account they can raise the support ticket. please refer to below Screenshot with different role who can raise support ticket

Thanks,

Prashanth

[ibarrau]

Hi. Make sure you are the owner of the dataflow, otherwise take over the dataflow at its configuration. Then try with a private session browser just in case a cache was making trouble. If the problem perssist, you can rise a ticket for support.

I Hope that helps

[kadirkkkk1]

I see that after editing a dataflow within 4 or 5 minutes i can not re-edit the dataflow (screen waits for a long time and gives that error like a timeout error), after some time it fixes itself and i can edit my dataflow again. Yes i should rise a ticket i think