Dataflows: Sorting data cached by enhanced compute...

Anonymous · ‎03-23-2021

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 · ‎03-25-2021

@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.