Material Quantification from Revit in power BI

[gokermu (Mucahit Bilal GOKER)]

Hey @Vineet_Srivastava ,

I’d be happy to help. Did you check this other threads on material quantities?

Get material takeoff in powerbi from speckle

Hey Roberto, If you are looking for the material “Parameters”, Material are sent as a separate collection. You can access their parameters from the parameter key. See screenshot below: [image] If you mean quantities, they are stored under the materialQuantities key and not under the parameters. So instead of extracting the parameters key, you should get it from element[materialQuantities]. [image] Sharing a sample model would make explaining it much easier.

How to extract value from Power BI list?

How can I extract information from a “list” from the “materialQuantities” parameter [image]

If these threads don’t help with your specific query, please share as much as possible (Speckle model URL, a sample file) with us, so we can help you better.