Material Quantification from Revit in power BI

[Vineet_Srivastava (Vineet Vinay)]

Hi @gokermu,
I am trying to create the material takeoff from revit model information in Power BI using speckle connector.
I am not able to get the specific material takeoff parameters like Material: Area, Material: Volume, Material: Name etc. and hence i am not able to quantify the revit assembly elements like walls, floors, roofs etc. separately.

Can you help me with this please?

Thanks,

Vineet

[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.