Hi @clrkng
I’m having issues retrieving branches in the PowerBI connector.
It doesn’t seem to like any branch URL i provide
However when I select specific commits, it works fine:
these are public:
branches I’m trying:
specific commit that works:
Got any ideas to help?
Hi @Joe_Landers ! Unfortunately the PowerBI connector doesn’t currently support branch urls - this is because there is no easy way to handle branch names with special characters or emojis in Power Query M (the language the connector is built with). Is this a big issue for you?
It’s not a major issue.
It would be useful to connect to the branch (which auto uses the latest commit). That way we can just refresh the PBI query and it will grab the latest data.
This will save time, rather than having to query a new commit, then transform the data each and every time the data changes.
Currently I’m just testing it out, so my transforms are limited.
I’m hoping to use Speckle to carry the geometry and results data for things like piles, retaining walls etc. and will use PBI to slice data. Thereby reducing the amount of files (like csvs and json) that we need to use. and just connect to Speckle streams for data results and visualisations.
That’s a good shout, we’ll brainstorm some workarounds and see if there’s another way to achieve this without having to work with branch names 
Hi there!
Really excited on this new tool. I have linked up a stream of mine to PowerBI but am only getting in a limited amount of data (57 rows of data from a model with 700+) elements. Any basic ideas where I may be going wrong?
Thanks for the help in advance.
-HW
Hey @hayden-wright!
Welcome to the community! Feel free to Introduce yourself 🙆 if you feel like it
Thank you for reporting this! I’ve been working on some fixes in PowerBI this week so I’ll have a peek to see what could be happening here.
Good news, @AlanRynne found a hacky hack to generate a fake url since the Uri parser only decodes the query. We should be able to support branches now!
Thanks Alan! Appreciate the assistance
Hey @hayden-wright! I just merged in this PR that should fix the problem you were having of missing items in the result table.
We’re now doing pagination on the queries, so it does take a bit more time to load (powerquery will fetch each “page” one by one before returning the entire result table)
We’ll look into speeding things up in the near future, but meanwhile you’ll be getting this in the next release! I’ll ping you here when its out!
Thanks for the updates to PowerBI. I have tested 0.0.5 version this afternoon, and it successfully connects to the branch of my stream. Immensely useful now for updating dashboards for visualising design (here’s visualising results from GSA)
Hi @Joe_Landers!!
That’s great! I’m glad you find it usefull!
I’m actually coding up today the last details for a new release that also brings better error handling and reporting, more available Speckle functions (like passing your own GraphQL query and getting back the result) and some UI improvements!
I’ll ping the community here once it’s ready. And as always, we look forward to your feedback once it’s released!
Look at those charts 
!
Let us know if you’d like to share a tutorial/blog post/case study at some point, we’d love to feature it on our website
Hey there!
Just wanted to let you guys know we’ve just released v0.0.6 of the PowerBI connector!
You won’t notice much has changed since the previous version, the main advantage is that we’re doing our best to catch any errors, so you won’t get cryptic NULL error messages anymore 
Feel free to download it from here: Release v0.0.6 · specklesystems/speckle-powerbi · GitHub
We’ve already planned some next steps, I’ll post a message about them right below so they can be discussed as much as necessary 
Hope to see more cool dashboards coming our way!
Sorry for the spam… but @SQMalik reported a bug in the connector that was an easy fix, so I just released version 0.0.7 on our GitHub repo.
We’re trying to polish the last details to consider the PowerBI connector stable, so we’d appreciate any feedback or bug reports
Grab the latest release from here Release v0.0.7 · specklesystems/speckle-powerbi · GitHub
Hi All, just wondering if there is anything in the pipeline for connecting to private streams in PowerBI?
Hi All, Im new to this space. I have followed the comments above regarding connecting a Speckle stream to Power BI but cant seem to connect my data. The stream is public but Power BI keeps telling me Im not authorised and unable to connect. Do you have any idea why this might be happening?
This is the stream URL.
Rico
Hi @Ricardo_Strinati !
Welcome to the forum and to Speckle !
Can you please confirm these are the steps you’re following and that you have the latest version of the connector?
Hi @teocomi
I am trying to get my (public stream) in Powerbi, but I keep getting the “you are not authorized” message. Any suggestions? Thanks a lot in advance! I followed all the steps as per your video.
BR, Bart
@Bart-Jan_van_der_Gaa @Ricardo_Strinati
We’ve tracked this issue and we’ll look into it asap! You could actually try to make the stream private, as @AlanRynne suggests in this post, in the meantime as a workaround and see if it works:
Hello @clrkng, I have been following up on this post and just checking if connector authentication work with the private stream by now? Thanks
