Was someone able to connect Speckle with PowerBI and Excel. I would like to compare some note here.
Hello @Alberto_tono, I still need to write docs on this. For now, i’m copy pasting from some internal docs we have in Arup (mind you, this applies to getting data in from a speckle endpoint):
You can use this as a base: https://hestia.speckle.works/api/streams/xxTNRBXwn/objects. It’s a random stream 
More or less the same applies to excel. There’s some extra steps this doc misses for now, but we’ll try and write it down in the docs as soon as possible.
1 Like
Thanks you so much,
What you guys are mainly importing in PowerBI,
are you able to achieve a similar result? Export Revit Rooms for use in a Power BI Shape Map Visual - YouTube
Not really yet. Proving ground’s video works with rooms. The Revit plugin is really at an early alpha stage (read: WIP), and for now you can export rooms, but not from the whole project. Better filtering and selection of what’s being sent from Revit is planned.
That being said, speckle can extract all that data, the rest is then just api queries and powerbi magic. We’ll get there 
2 Likes
Hi Dimitrie,
I was able to make it works , I had a lot of fun with the query builder of PowerBi,
now my next step would be to be able to have a live-connection with PowerBI web,
is it feasible? or would you recommend to create live dashboard visualization directly in Speckle?
Kind Regards
Hey Alberto, if you can automatically refresh the query in powerbi then it can be “live” (poll every minute or so?). I’m afraid that I don’t know anything much about powerbi though…
Building your own will be much more time consuming, but then you can subscribe to the websocket events for proper event handling. I wouldn’t recommend this route unless you have too much free time on your hands though 
1 Like
Is there a beta for speckle-excel I can download and try on an Arup project?
1 Like
Instructions are here. We’re working on this to get it on the microsoft’s app store, but we’re not there yet. All credits go to @mishaelnuh for this 
1 Like
Hi Alberto, can you tell us more about the queries you used to achieve a similar result? Export Revit Rooms for use in a Power BI Shape Map Visual - YouTube ?
1 Like
Quick note that this thread is Speckle 1.0. There’s a new speckle excel connector that @teocomi pushed out, with new docs for it: Excel | Speckle Docs
It has a much friendlier interface and allows you to curate what data you receive in excel from a speckle revit model (and even select specific fields only).
3 Likes
Thank you so much for your help
1 Like