Forum Discussion
DataflowGen2 Slow Performance during design is HORRIBLE
Hi ToddChitt,
I apologize for any inconvenience. Here are the two documents that explain Trail vs Premium. Please review the links below for a better understanding:
Trial Capacity (F64)- Typically time-limited (e.g., 60 days).
- May have restrictions or limitations compared to a paid capacity.
- Designed for evaluation purposes.
Purchased F64 Capacity
- A fully paid, production-ready capacity.
- Includes service level agreements (SLAs) and comprehensive support.
- Ensures uninterrupted access as long as the subscription remains active.
While both options provide comparable compute power, please note that the trial version is temporary and may have certain limitations compared to the purchased capacity.
Please refer to the below links for better understanding:
Fabric trial capacity - Microsoft Fabric | Microsoft Learn
What is Power BI Premium? - Power BI | Microsoft LearnAlso, kindly refer the below link for more information:
Microsoft Fabric concepts - Microsoft Fabric | Microsoft Learn
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi ToddChitt,
After thoroughly reviewing the details you provided, I have identified alternative workarounds that may help resolve the issue. Please follow these steps:
Although Git integration is locked, please create a new workspace without it and check if it functions properly. An admin should review the settings in the Fabric Admin Portal > Workspaces and compare them with a functional workspace.
Remove stored credentials by navigating to Fabric Home > Settings > Data Sources. Delete any existing credentials for SharePoint, Lakehouse, and Warehouse, then re-authenticate. Reconnect Data Sources by manually adding SharePoint, Lakehouse, and Warehouse connections again and verifying if they work.
In the Fabric Admin Portal > Capacity Metrics, check CPU and Memory Usage during periods of slow performance. If high usage is detected, schedule Dataflow work during low-usage hours.
If the issue persists after attempting all the workarounds, please consider raising a Microsoft support ticket. You can create a support ticket using the following link:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi ToddChitt,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi ToddChitt,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.I did some testing:
First, a parallel test of the one workspace against another tenant: same operation(s). The other tenant performed just fine. Second, I created a new Workspace in the same tenant (and under the same Trial Capacity) and THAT worked fine. My conculsion is that there was something about the workspace.
Since I was very early on in the development process, I simply recreated the artifacts in the new workspace and have now deleted the one that was having performance issues.
We meay never know what the cause of the slow performance was. As I said, the issues came around some very basic operations, like while setting up a Dataflow Gen2 destination, it would take 10 minutes to 'browse' the list of available lakehouses.
But now I am EXTREMELY curous about your statement:
- Yes, that’s correct. A Trial Capacity (at F64) and a purchased F64 Capacity are not the same.
Everything I read from Microsoft documentation says that a Free Trial is the same as an F64 Capacty, just that you don't have to pay for it. Please provide documentation to support your statement.
The only documented limitations of the trial capacity I have seen is the trials do not support autoscaling and they do not support AI skills.
