Forum Discussion
Editing Dataflow error code "status code: 500"
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/
12 Replies
I'm having the same issue this week. I'll raise a support ticket as well.
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.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.🙄
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
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
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
I dont have a Fabric subscription plan to report bugs on Power BI
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
I'm having the same issue this week. I'll raise a support ticket as well.
