Hey @bmc, you are not doing anything wrong, per se, but you are seeing the impact of reviewing a data structure that isn’t strictly table based on a table which PowerBI expects.
That record with a referencedId is a by-product of how Speckle stores sub-elements and instances of Revit Types. The material data is held on another row with that id. Essentially the web viewer does some work for you in gathering those data in one place. We are looking to improve our PowerBI connector to have similar functionality. In the meantime, I have demoed two approaches to doing so … both require a bit more detailed knowledge of PowerQuery.
Resolving Instance/Detached Data in PowerBI with Self-Joins:
Resolving detached data with Recursive PowerQuery:
You can follow either approach, but we want an option for users such as yourself not to touch a line of PowerQuery but instead see the web data OOTB. Expect development on this in the future.