We've setup the On-Premise Data Gateway to connect to a PostGRES database we have.
When we run the PostGres Get Rows action in our Power Automate Flow, I get some really strange results.
I'm returning just 1200 rows, but what's strange is I'm getting many duplicate rows, and lots of rows are missing. Oddly, I'm getting the exact right "record count", but it's not the right records. I'm using the Order By.
I've set Pagination to a big number, off or on with Asynchronous, set Max Rows to a big number, Skip Rows to 0 and tested pretty much every variation of these settings, and it always delivers data that is really off.
What am I missing here? Anyone had a similar issue?
Thanks,
Ben


Report
All responses (
Answers (