when i load room value parameters data to get visualize screen. the below error message comes.
please suggest the way forward.
Are there other data sources in your workbook?
i don’t know, now its working fine. but how do i get colors to the 3d view. at present i can see only one color to entire project. which is very difficult to understand.
plz refer below image
thank you, its quite impressive. 
i have one doubt. in the query edition the rooms/level names/area/number are counting double, i don’t know why. due to this every data counting in double in the reports. refer below two snapshots. from power bi and revit .
from power bi
Are you performing data joins that could be accountable or is this entirely the stream coming from Speckle? It would be very odd to see two objects with identical ids coming from the data connector
i m not performing any data joints, it’s entirely comes from steam speckle.
i am facing two issues,
when data comes correctly then 3d view is not appearing in power bi.
when 3d view appearing then data is shows double in power bi.
could u plz share the video / snapshot, how to export from revit and when i load in power bi, both data & 3d to be appearing correctly.
is extraction from revie wrong?
can i send the URL link
there are two speckle websites are available. which one to use in power bi.
and
I can confirm that project dataset is indeed offering duplicate info when flattened. I’ve not seen this before, and I’ll need to investigate why this is happening and see if we can determine why and fix it.
There are 546 rooms in the model, and PowerBI IS reporting 1092 
For now, in the meantime, a simple Deduplicate Rows on the object ID is the simple workaround:
This I cannot replicate
I have these settings, and I am sharing the workbook:
Rooms deduplicated.pbix (1.1 MB)
1 Like
awesome, thank you for well clarifications with process snapshots.
appreciated.
regarding appearance of 3D model in power bi . i found the solution that i need to enable the link share, then we can get the model appearance in power bi.
Speckle is good tool i just started to learn, but, i think to extract parameters data some coding/formulas needed. is it right ?
There are some power query steps to make this is correct. Fortunately @gokermu has a set of tutorials that will help:
how do i delete all the models from speckle.
