Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is there a way to sort data cached by enhanced compute engine(ECE)?
I use first dataflow to ingest data form SQL server where I sort data in a desired way. I added index to check sorting and it works ok. When I use second dataflow that is linked with the first one I use ECE to speed up transformation but then the sorting is being lost. PQ online editor is showing the proper sorting but when I refresh data it is being loaded with different sorting order. The reason is that data for refresh is being sucked from cache. When I turn off ECE than it works ok but I loose performance speed. Any ideas?
@Anonymous
With my research, there is no relevant information regarding to sorting when using ECE, you may only re-sort the order in the report visual created in the dataflow. Maybe you can try increase the Container Size.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.