BUG - Table visual - odd summarization

[barritown]

As you can see on the screenshot, though the option "Don't summarize" is in place, one entry is missing in the Table visual.

Diagnostics:

Feedback Type:
Frown (Error)

Timestamp:
2023-07-08T22:46:39.4368894Z

Local Time:
2023-07-09T01:46:39.4368894+03:00

Session ID:
f5cc7cfc-fd2a-4bfd-9348-4c9c59d326d9

Release:
June 2023

Product Version:
2.118.1063.0 (23.06) (x64)

OS Version:
Microsoft Windows NT 10.0.22621.0 (x64 ru-RU)

CLR Version:
4.8 or later [Release Number = 533320]

Peak Virtual Memory:
70.1 GB

Private Memory:
528 MB

Peak Working Set:
806 MB

IE Version:
11.1.22621.0

User ID:
3e42d4d7-f7d6-46e3-8ba1-681567a183d3

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

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\alexa\Microsoft\Power BI Desktop Store App\FrownSnapShot6ff88ece-9dc0-4d00-9340-b113ab8edabd.zip

Model Default Mode:
Import

Model Version:
PowerBI_V3

Performance Trace Logs:
C:\Users\alexa\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion
PBI_setLabelOnExportPdf
PBI_newCard

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_angularRls
PBI_onObject
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_gitIntegration

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
175%

Supported Services:
Power BI

Formulas:

section Section1;

shared data = let
Source = Excel.Workbook(File.Contents("D:\Projects\Power BI\episode 24\data-tom-**bleep**-harry.xlsx"), null, true),
data_Sheet = Source{[Item="data",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(data_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Name", type text}, {"Points", Int64.Type}})
in
#"Changed Type";

[Anonymous]

Hi  @barritown ,

I tried to do a simple test but it doesn't seem to reproduce the problem, any more information would be great.

can you provide a sample pbix or a detailed reproduction step? (Please be careful not to include sensitive information)

Best regards.
Community Support Team_ Caitlyn

[barritown]

Hi @Anonymous,

Sure.

Here's the video where I reproduce this bug from scratch - https://drive.google.com/file/d/1-z4jHbMybXI7n2T_O_kqUZIjB_3U2O6v/view?usp=sharing

Here's the PBIX file - https://drive.google.com/file/d/105DTg_A9ol1TYu22OebufrD3KyuzCRi_/view?usp=sharing

If you failed to reproduce the bug, I guess my file should look perfectly normal in your environment.