Forum Discussion
Solved
Issue with Missing Data in Power BI for Postgres Database on Azure
Hi all, I’m using Power BI Pro and connecting to a PostgreSQL database hosted on Azure. The table I’m working with is called CRS, which contains over 3 million records. However, when importing data ...
Hi Aasif_Khan ,
You can refer to the official Microsoft documentation on the Power Query PostgreSQL connector below. It explains how Power BI connects to PostgreSQL, how query folding works, and what to check if some records don’t appear as expected:
Power Query PostgreSQL connector - Power Query | Microsoft Learn
Best Regards,
Community Support Team
kushanNa
Super User
Super UserHi Aasif_Khan
As far as I know, Power BI has a limit of 1 million rows per query call, so maybe you’re hitting that limit. https://www.sqlbi.com/articles/tuning-query-limits-for-directquery/?utm_source=chatgpt.com