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 into Power BI (whether in Import or DirectQuery mode), the total row count I’m seeing is only 1,712,720 records, and this count is only up-to-date as of August 11, 2025.I’ve tried running the following query to filter the records based on the checkout_date field:"SELECT * FROM CRS WHERE checkout_date > '2025-10-01';"But even when using this filter, I’m not getting any data at all.Does anyone know why this might be happening? Any suggestions on how to resolve this issue would be greatly appreciated!Patrik Taylor danextian Thanks in advance!

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 LearnBest Regards, Community Support Team

Issue with Missing Data in Power BI for Postgres Database on Azure

13 Replies

kushanNa
Super User
10 months ago
Hi 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
Shahid12523
Community Champion
10 months ago
Run SQL directly in pgAdmin to confirm recent data exists.
Check if Power BI is applying query folding or limiting rows.
Make sure CRS isn’t a view or partitioned table excluding recent data.
Validate time zone alignment in your date filter.
Confirm checkout_date is a proper timestamp field.
- Aasif_Khan
  New Member
  10 months ago
  Shahid12523 I have checked that, data exist in database, also checked query folding, it's working fine.
  I don't think it's a view because I can see the complete data on one of our tool as well.
mveli
New Member
10 months ago
Feedback Type:
Frown (Error)
Timestamp:
2025-10-13T12:22:52.7045025Z
Local Time:
2025-10-13T14:22:52.7045025+02:00
Session ID:
865941a5-8ef4-46cc-bb63-ef8860e69f96
Release:
September 2025
Product Version:
2.147.1085.0 (25.09)+45152489d034fc6d7b56e091d0b88cef22d9e214 (x64)
Stack Trace:
System.ArgumentNullException
at Microsoft.PowerBI.Modeling.Common.Contract.FailArgumentNullCore(String msg)
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingQueryAdapter..ctor(Query query)
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingHostingExtensions.<>c.<ToModelingQueries>b__1_0(Query q)
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
at System.Linq.Enumerable.<ExceptIterator>d__73`1.MoveNext()
at System.Linq.Enumerable.<UnionIterator>d__67`1.MoveNext()
at System.Collections.Generic.HashSet`1.UnionWith(IEnumerable`1 other)
at System.Collections.Generic.HashSet`1..ctor(IEnumerable`1 collection, IEqualityComparer`1 comparer)
at System.Linq.Enumerable.ToHashSet[TSource](IEnumerable`1 source, IEqualityComparer`1 comparer)
at Microsoft.PowerBI.Modeling.Engine.Loader.QueryLoadCalculator.CalculateLoadOperations(IModelingSession session, ModelingMashupDocument modelingMashupDocument, IMashupDiscoveryService mashupDiscoveryService, QueryLoadStages queryLoadStages, IEnumerable`1 inputQueries, Boolean isRelationshipImportEnabled, Boolean isRelationshipRefreshEnabled, ITelemetryService telemetryService, IModelingQueryServices modelingQueryServices, IEnumerable`1 mashupIneligibleTablesToRefreshData)
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.DesktopModelingHost.TryPrepareLoadToModel(Report report, Action`1 beforeSchemaSyncCallback, Action`1 afterSchemaSyncCallback, String loadReason, QueryLoadStages queryLoadStages, IExceptionHandler exceptionHandler, IPowerBIWindowService windowService, IEnumerable`1 queries, ITelemetryService telemetryService, LoadToModelContext& loadToModelContext, Boolean throwOnFirstLoadFailure, IEnumerable`1 mashupIneligibleTablesToRefreshData)
at Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.<>c__DisplayClass19_0.<TryShowDialogForQueries>b__0()
at Microsoft.PowerBI.Client.Windows.Report.<>c__DisplayClass82_0`1.<SynchronizeLooselyWithQueries>b__0()
at Microsoft.PowerBI.Client.Windows.Report.<SynchronizeLooselyWithQueriesAsync>d__83`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.Client.Windows.Utilities.AggregateExceptionHandlingExtensions.WaitForResultAndUnpackException[T](Task`1 task)
at Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.TryShowDialogForQueries(Report report, IExceptionHandler exceptionHandler, IPowerBIWindowService windowService, IPowerBIQueryErrorEditor queryErrorEditor, IEnumerable`1 queriesToApply, String loadReason, ITelemetryService modelingTelemetryService, QueryLoadStages queryLoadStages, LocalizedString title, Action`1 beforeSchemaSyncCallback, Action`1 afterSchemaSyncCallback, Boolean synchronizeLooselyWithQueries, IEnumerable`1 mashupIneligibleTablesToRefreshData)
at Microsoft.PowerBI.Client.Windows.Services.WarningDetectionService.<>c__DisplayClass63_0.<DetectTablesWithMissingData>b__4()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.147.1085.0","ModuleName":"Microsoft.PowerBI.Modeling.Common.dll","Component":"Microsoft.PowerBI.Modeling.Common.Contract","Error":"System.ArgumentNullException","MethodDef":"FailArgumentNullCore","ErrorOffset":"28","ErrorCode":""}
OS Version:
Microsoft Windows NT 10.0.26100.0 (x64 en-US)
CLR Version:
4.8 or later [Release Number = 533320]
Peak Virtual Memory:
73.3 GB
Private Memory:
2 GB
Peak Working Set:
1.95 GB
IE Version:
11.1882.26100.0
User ID:
aad14f14-5a0c-4955-88ef-48b685ff2eac
Workbook Package Info:
1* - en-ZA, Query Groups: 0, fastCombine: Enabled, runBackgroundAnalysis: False.
Telemetry Enabled:
True
Model Default Mode:
Import
Model Version:
PowerBI_V3
Enabled Preview Features:
PBI_googleBigQueryAdbcVersionEnabled
PBI_scorecardVisual
PBI_setLabelOnExportPdf
PBI_oneDriveSave
PBI_oneDriveShare
PBI_odspSaveBackgroundUpload
PBI_modernOfficeFilePicker
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_tmdlInDataset
PBI_enhancedReportFormat
PBI_directLakeOnOneLake
PBI_newCard
PBI_buttonSlicerAuthoring
PBI_advancedSlicerTypeList
PBI_textSlicer
PBI_daxInlineCopilot
PBI_aiNarrativesVisual
PBI_visualCalculationsAuthoring
PBI_copilotUnifiedTooling
PBI_UserInstalledVerticaODBCDriver
PBI_sqlDbNativeArtifactsOnDesktop
PBI_dataFunctionActions
Disabled Preview Features:
PBI_DatabricksAdbcVersionEnabled
PBI_snowflakeLegacyOdbcVersionEnabled
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_metricsArtifactsOnDesktop
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_onObject
PBI_publishDialogsSupportSubfolders
PBI_enhancedReportFormatPBIX
PBI_qnaImproveLsdlCopilot
PBI_customCalendars
PBI_UserInstalledNetezzaODBCDriver
MashupFlight_EnableOracleBundledOdacProvider
PBI_supportUDFs
Enabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
125%
Supported Services:
Power BI
WebView2 Runtime Version:
141.0.3537.71
WebView2 SDK Version:
1.0.2365.46
danextian
Super User
10 months ago
Have you tried creating this view instead. I have an imported dataset sitting in Azure SQL that's way over 3 million so I don't think the number of rows is the issue.
- v-menakakota
  Community Support
  10 months ago
  Hi Aasif_Khan ,
  Thanks for reaching out to the Microsoft fabric community forum.
  
  I would also take a moment to thank danextian   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
  
  I hope the below details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you
  
  Best Regards,
  Community Support Team
- Aasif_Khan
  New Member
  10 months ago
  Hi danextian which view are you talking about?
  - v-menakakota
    Community Support
    10 months ago
    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
Aasif_Khan
New Member
10 months ago
hi kushanNa ,
Thank you for your reply.
I don't think so that's the issue here because while using query to retrieve row only for this month also not working.
- kushanNa
  Super User
  10 months ago
  hmm interesting, have you tried using a tool like pgAdmin Desktop to run the query in parallel with Power BI Desktop in your local machine and see if there’s any mismatch?
  - Aasif_Khan
    New Member
    10 months ago
    Sure, kushanNa , I'll try that one as well.
    Thank you for your support

Forum Discussion

Issue with Missing Data in Power BI for Postgres Database on Azure

13 Replies

Related content

Connector Postgre SQL DATABASE

Postgre connection

Missing several database connectors

missing data

missing data