Power Query Error Message: 'Argument is out of range'

[durhamdatauser]

Error within Power Query. Copied details and they're found below!

Feedback Type:
Frown (Error)

Timestamp:
2024-01-04T03:47:09.6118845Z

Local Time:
2024-01-03T22:47:09.6118845-05:00

Session ID:
beafda86-071e-43f7-9bee-de4fb0951c3a

Release:
December 2023

Product Version:
2.124.1052.0 (23.12) (x64)

Stack Trace:
Microsoft.Mashup.Host.Document.JavaScriptException
at GridResultControl.prototype._getColumnIndex (ms-pbi://pbi.microsoft.com/ts/Controls/Results/GridResultControl.js:262:17)
at getColumnIndex (ms-pbi://pbi.microsoft.com/ts/Controls/Results/Table/TableResultControl.js:256:67)
at GridResultEventHandler.prototype._onColumnHeaderMouseDown (ms-pbi://pbi.microsoft.com/ts/Controls/Results/GridResultEventHandler.js:132:17)
at Anonymous function (ms-pbi://pbi.microsoft.com/ts/Controls/Results/GridResultEventHandler.js:35:21)
at n.event.dispatch (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:3:7481)
at r.handle (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.2.4.js:3:5547)

System.ArgumentOutOfRangeException
at Microsoft.Mashup.Host.Models.Verify.IsInRangeInclusive(Int32 argument, Int32 rangeStart, Int32 rangeLength, String argumentName)
at Microsoft.Mashup.Client.UI.Shared.PageManager.GridPages.GetPageColumn(Int32 pageColumnIndex)
at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Results.Grid.GridResultHtmlControl.GetStartColumnIndex(Int32 columnPageIndex)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.124.1052.0","ModuleName":"Microsoft.Mashup.Client.UI.dll","Component":"Microsoft.Mashup.Client.UI.Shared.PageManager.GridPages","Error":"System.ArgumentOutOfRangeException","MethodDef":"GetPageColumn","ErrorOffset":"49","ErrorCode":""}

InnerException0.Stack Trace:
at Microsoft.Mashup.Host.Models.Verify.IsInRangeInclusive(Int32 argument, Int32 rangeStart, Int32 rangeLength, String argumentName)
at Microsoft.Mashup.Client.UI.Shared.PageManager.GridPages.GetPageColumn(Int32 pageColumnIndex)
at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Results.Grid.GridResultHtmlControl.GetStartColumnIndex(Int32 columnPageIndex)

OS Version:
Microsoft Windows NT 10.0.17763.0 (x64 en-US)

CLR Version:
4.7.2 or later [Release Number = 461814]

Peak Virtual Memory:
72.5 GB

Private Memory:
1.88 GB

Peak Working Set:
2.12 GB

IE Version:
11.1790.17763.0

User ID:
87d4185e-4d47-48c2-a602-a72cf997ff74

Workbook Package Info:
1* - en-US, Query Groups: 24, fastCombine: Enabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Model Default Mode:
Import

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_setLabelOnExportPdf
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_newCard
PBI_buttonSlicerAuthoring

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_angularRls
PBI_onObject
PBI_backstageUI
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_modelExplorer
PBI_daxQueryView
PBI_aiNarrativesVisual
PBI_qnaImproveLsdlCopilot

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[Anonymous]

Hi @durhamdatauser ,

Based on the information you provided. If you’re trying to perform an operation on a column that contains different data types (for example, text and numbers in the same column), you might encounter this error. You can handle this by replacing errors with null values.

If you’re trying to group rows and encountering this error, it could be due to the data type of the column you’re trying to group. Try changing the data type of the column to a suitable one.

You may also check if your data has empty rows, it might cause this error. You can filter out empty rows to resolve this issue.In some functions like , a negative count argument can cause this errorList.Dates. Make sure the count argument in such functions is positive.

Best regards.
Community Support Team_Caitlyn