topic Re: DATA EXCHAGE FOR POWER BI - DOUBLE ENTRY in Data Exchange Forum

DATA EXCHAGE FOR POWER BI - DOUBLE ENTRY

RVIENG — Mon, 29 Jun 2026 15:35:25 GMT

I really need help with this strange behavior in PowerBI
Please refer to the image blow: one element selected, two IfcTags shown.
At the same time, the element that should have the second IfcTag, has nothing.
[data exchange from Ifc file]
Thank yo u

Re: DATA EXCHAGE FOR POWER BI - DOUBLE ENTRY

Radwan-Almsora — Mon, 29 Jun 2026 19:20:38 GMT

The issue happens because the Power BI data model maps relationship tables incorrectly or lacks unique entity keys.Why the Double Entry OccursMany-to-Many Relationship Issues: The structural element is mapped to a generic IfcType or Tag (BS03) instead of its unique instance ID.Lack of Unique Instance Binding: Power BI matches the Tag prefix "BS03" to all instances sharing that prefix (BS03.548 and BS03.572) because the relationship is evaluated at the type level rather than the individual instance level.Missing Bridge Table: A direct link between a type table and an instance table creates duplicate rows in your visuals.

How to Fix ItVerify the Key Column: Ensure your Power BI relationship links the GlobalID or a specific instance GUID, not the generic Tag or Name.Implement a Bridge Table: Create a distinct mapping table containing unique combinations of GlobalID and the specific sub-tag if your source data splits them.Filter by GlobalID: Add the GlobalID field (2bMGnb...) into your Power BI visual or table filters to force the report to display data for only one specific element.

don't forget to click the Accept Solution button

Re: DATA EXCHAGE FOR POWER BI - DOUBLE ENTRY

RVIENG — Mon, 29 Jun 2026 20:07:41 GMT

answer not accepted, there is no mapping involved here.

Re: DATA EXCHAGE FOR POWER BI - DOUBLE ENTRY

lejla.s — Wed, 01 Jul 2026 06:53:14 GMT

Hi @RVIENG ,

this is indeed very strange, I'm guessing it might be caused by some complex relationships in the actual IFC model (groupings, Element > Type, or similar) - would it be possible to share the .pbix dashboard and the IFC with our team through data.exchange.support@autodesk.com ?

We might also need access to your Data Exchange, but we can discuss this via E-Mail.

Thank you - we'll make sure to unblock you asap!

Best,

Lejla

Re: DATA EXCHAGE FOR POWER BI - DOUBLE ENTRY

RVIENG — Wed, 01 Jul 2026 08:27:56 GMT

@lejla.s
thank you for your kind reply.
I am really struggling to make this IFC data connector reliable.
I was happy to make it work with Revit files, and indeed I succeeded in connecting my estimates with the model

Linkedin Post
https://www.linkedin.com/posts/robertovalentino_dato-nel-modello-dato-del-modello-un-errore-ugcPost-7477342562350190593-Zh4v/?utm_source=share&utm_medium=member_desktop&rcm=ACoAAB80ObkB9oJeJnJvDmIT3O7UGHyJzkKSBP0

I need this to work with IFC's though, and I need it reliable otherwise my clients loose confidence in the workflow.
Sending an e-mail as you suggested
Thank you again