Speckle and PowerBI with Excel


#1

Was someone able to connect Speckle with PowerBI and Excel. I would like to compare some note here.


#2

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 :slight_smile:


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.


#3

Thanks you so much,
What you guys are mainly importing in PowerBI,
are you able to achieve a similar result? https://www.youtube.com/watch?v=c57QjEJfUVU


#4

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 :sunglasses:


#5

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


#6

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 :wink: