Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Laser_Tim_88
Advocate I
Advocate I

Power Automate Visual - Not Sorting Data

Hey PBI,

 

So I am using Power BI to transofrm and analyze production data in my organization then using the Power Automate Visual to send that data back to the production line for them to use. 

 

I am using Direct Query and some other Import Tables as my data source. After all the clean up, I combine all related data in one Table Visual on the report page. I am using the exact same Data from the Table Visual for the Power Automate Visual.

 

 The Table Visual has to be sorted by multiple columns in a specific order. 

 

Sort By.PNG

 

Everything is fine in the Table Visual, though when I export the Data manually or when I trigger the Power Automate Visual, all of the data is not sorted as the Table Visual. 

 

Table Visual:

Sorted Table.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Power Automate Visual:

Power Automate Visual.PNG

 

Is there something I can do to keep the sorting order of my Data when it gets sent to the Flow?

Any idea why the sort would be lost? Any help or fixes for this would be great!

 

Thanks for reading!

 

0 REPLIES 0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.