Forum Discussion
Data Source preview does not pass LIMIT to PostgreSQL database, unable to query large tables
Hi JesterUK
You might try changing the number of rows previewed in Power Query to the full dataset.
I found a document with a similar problem to yours for your reference:
Solved: How to increase the number of rows in preview at P... - Microsoft Fabric Community
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous , thank you for your investigation - unfortunately this is the opposite of what I want to happen! I want to apply the limit in the SQL query that goes to the database. What you're suggesting would try to pull in the entire table; which would never work with over 400M rows in just one month!
Thanks for looking into it though, I appreciate it.
