I have successfully connected the speckle stream to Power BI using connector and seeing all the data in table in PBI. I have added speckle visual in PBI as well and added stream url and object id but model is not loading in visual, am I missing something?
@teocomi Fair enough just discovered Speckle recently and I am impressed with all the interoperability. Actually I am trying to test it for some of my workflows. I offer myself to help the platform to grow testing it and giving my feedback… I work in construction actually integrating 3D models and data and doing analysis in powerBI.
Thanks for your reply and great job to the entire team… looking forward to integrate speckle even more!
Could you give an update on when you think private streams are supported in the Power BI Speckle viewer? I can imagine it can be a tricky issue! A few colleagues are testing Speckle in Power BI but they can’t use it yet with project data due to this limitation.
The restriction rests on how that authentication to a private stream might exist. MSoft didn’t build the visuals API anticipating external calls, so other solutions bake the geometry into the data query layer. This is also why Speckle Viewer visual is not on the MSoft marketplace.
The options for deploying authentication are up for debate/opinion/discussion. And are not particularly preferable to making a stream public and non-discoverable.
Embed a PAT token in the dashboard/visual config if extracted, allows the dashboard user to impersonate the token owner
Store that token in the stream data, in globals, for example this is even worse a security risk
The remaining option is the Data Connector side-loads the data into the viewer. This requires changes to the Viewer itself before getting to the visual. It may bring advantages as the Query already retrieves all data for each object, which could be advantageous for that reason, but not in the current viewer API.
Thank you for the quick reply and clarification Jonathon!
To me, it sounds like this option does make the most sense. It will be in similar to how other solutions deal with it.
Without the ability to securely pull from a private Speckle stream project, we unfortunately have to discourage our project teams to use it on projects to prevent issues related to data and legal requirements because non compliance can result in very severe implications.
With the new Speckle viewer API, would it be possible that this change makes it to the roadmap because it would enable our project teams to use the Power BI connector on live projects? I can imagine others might have the same security needs as well.