Forum Discussion
Issue with Missing Data in Power BI for Postgres Database on Azure
- 11 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
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