You’re offline. This is a read only version of the page.
11
Share
ReportDeliveryPostalAddress" is present in my Aggregate Measurement and exposed to the report, but at runtime the visual fails with Invalid column name.Repro (short):
Add DeliveryPostalAddress to AM → Build + DB Sync.
Full Entity store refresh.
Publish/Refresh Power BI dataset.
Open visual → error above.
What I checked/tried:
Full build + DB sync after adding the field.
Full Entity store refresh (not incremental).
Re-publish the PBIX / refresh dataset in Service.
Field appears in AM designer and in the model.
Still get Invalid column name 'DELIVERYPOSTALADDRESS'.
DELIVERYPOSTALADDRESS/LOGISTICSPOSTALADDRESS) or an extra step to force the column into AxDW?
All responses (
Answers (
DELIVERYPOSTALADDRESS, even though your Aggregate Measurement (AM) metadata shows it. That mismatch usually happens when the field was added to the AM but not actually materialized into the underlying aggregate view that gets published to AxDW, or when the field is a display/computed X++ method that doesn’t translate to SQL.
