And here is an in depth tutorial on how to create those quantity takeoff dashboards containing quantity information from the sketchup model, combined with pricing information from a central excel sheet: 3D Power BI visual of a BIM quantity takeoff with external pricing information - in depth tutorial. - YouTube
And here is that tutorial written out: How-to – 3D quantity takeoff dashboard in Power BI | KG-dev