Hey @Shantiwit ,
We have a playlist available for working with Revit data in Power BI. I suggest you check out this playlist:
https://youtube.com/playlist?list=PLlI5Dyt2HaEsZHG2WJ75WIM0Brx6VHT2S&si=huvUdMb1QLaA_osY
Methods shown in these tutorials can be used to extract any parameter including material quantities. You can take a look at this thread to understand how to access material quantities in Power Bi. TLDR: it’s under materialQuantities key in the objects. Quantities like length, volume and area are available for each material in addition to a lot of the material properties.