I’m facing an issue with the for Revit, when trying to import data into Power BI. I am uploading a Revit architectural model along with a structural file linked to it. However, upon attempting to view the data in Power BI, I encounter the following error:
“‘Too many Stream URL’, ‘Commit object ID’ values. Not displaying all data. Filter the data or choose another field.”
This is preventing me from displaying the data properly in Power BI.
Has anyone else encountered this issue? Are there any suggestions to fix it,
Thank you for your response. Could you upload a video demonstrating how to handle large amounts of data when exporting from Revit to Power BI? A visual example would provide better clarity on customizing the data effectively.
Additionally, I attempted to extract quantities based on materials created in Revit but couldn’t find a “List” or “Report” for it. The data seems to be available only at the type level. For instance, if I’ve created a wall type named ‘Int. Wall’ and added a material layer such as ‘Int. Plaster’ on both sides of the wall, I can retrieve the quantity for the wall type (‘Int. Wall’) but not for the specific material layer (‘Int. Plaster’).
While I can see the material names created in Revit and I can Extract the same, their quantities are not available.
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.