Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
So, I am using Power BI to transform 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 cleanup, 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.
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:
Power Automate Visual:
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!