Revit Instances in Power BI

[gokermu (Mucahit Bilal GOKER)]

I turned this into a function. Take a look at this thread:

Filtering data in power BI recieved from Revit by category & family & type

Ok, i think i know what’s going on. You have lots of instances in your model and those instances don’t directly have the “category”, “type”, “parameters”, “zone” fields you were referencing too. You can learn more about what instances are in this blog. @jonathon shared a workaround for this problem using Power BI. We need to relate these instances back to their reference elements/types. I converted @jonathon 's suggestion into a Power BI function. Please refer to the following guide for more …