I am unable to connect speckle to Powerbi. Infact, I am not even getting the option of Speckle (Beta) in the Get Data option of Powerbi.
I did check in the “Not Recommended” box in Security options.
I think I am missing something. Please guide me.
Hi, what’s the full path to the folder you are dropping the Speckle.mez file into? Also which release are you currently trying to use?
Hey @clrkng ,
I am currently using speckle 2.1.11. I found out that I didn’t drop the Speckle.mez into the specified folder.
Now, I was searching for the folder to drop the .mez file. But I can’t seem to find the specified folder for dropping the .mez file " YOUR_USER_FOLDER\Documents\Power BI Desktop\Custom Connectors ". I googled it whether if my installation was wrong, and found that there were similar cases before but the solution is not clear and can’t be resolved by reinstalling the software.
Any idea, with regards to this will be really helpful.
This may sound silly… and not sure if it will do the trick but, have you tried just creating that folder structure inside your documents folder and placing the .mez file there?
ahahaha! I will give it a try right now!
I did try that and unfortunately not working.
I was looking at the options in PowerBi, where we give permission to allow external connectors,
But, I don’t have that option in my Power BI desktop. Could it be that’s the reason it is not working?
This makes me sad . Maybe we’re missing some clarification in the Installation guide?
As for your missing option, I think you may be in the wrong tab Check in
Unfortunately that seems like it’s the only solution: did you check that the path spelling & spacing is correct? Also, do you have the data gateway installed by any chance? Also, PowerBI needs to be restarted after dropping in the .mez file
Hey @AlanRynne ,
I did opt for the option in ‘Security’ tab for non recommended extensions. Unfortunately, it doesn’t give us any desired result. I think this is one of the edge cases. Also, an info of my current PC status, I am working with a local account this might be the case. I wasn’t able to test this on administrative account.
@clrkng I did check the path spelling, and spacing as well. I think, I am missing some info with regards to PowerBI external connectors. I will look there.
Thank you @AlanRynne and @clrkng
Thanks for getting back to us @SQMalik. I’ll dig a bit further on my side too, and try to figure out what could be going on.
Maybe for local accounts the PowerBI connectors path is different? Do keep us posted if you find anything useful, as I’m sure you won’t be the last user with this problem.
I finally found the mistake! It was spelling error in the folder name.
Thank you for your time!
Good to know!! Looking forward to your feedback on the PowerBI connector. Any ideas on how to improve it will be very appreciated!
Hey @AlanRynne ,
It would be really easy for people, if we could have small clips of all steps involved in loading and deploying data using speckle in power bi. It seems like spoon feeding, but it can save people tons of time and make it more user friendly.
I uploaded my stream on Power BI. Unfortunately, I couldn’t see any output.
I am uploading screenshot of this.
Quick question, do we have any material on how to operate power bi for speckle?
Any guidance would be really helpful!
The stream is as follows:
Instead of copying the main branch url, could you try copying stream home url? I think PowerBI connector doesn’t support branches at the moment (yes, even when it is the main branch).
We are supporting branches with the latest version of the connector!
This is probably because the PowerBI connector isn’t handling cases where the commit is just one single object and not wrapped in a commit
Base object. We’ll look into fixing this case in our connector, or changing the way the Dynamo connector sends single objects. Thanks for reporting it!
Meanwhile, can you check if you’re still getting this issue when retrieving data from commits that are structured like the image on the right:
Also, we’ll post a video and guide on how to get started with the PowerBI connector soon, now that it’s more stabilized. Hopefully that’ll help address common issues like installing the connector and receiving data
hello @gokermu ,
I did try that. Unfortunately, it didn’t work!
@clrkng Thank you for the support! Quick question, how do I get my missing ‘Base’ case?
From Dynamo, if you send more than one object it should be attached to a commit
Base. This was an oversight on our part about not using a
Base container only for single objects, we’re currently discussing whether or not we should change the connector to always send with
Base at the root regardless of object count!
Hey @clrkng ,
Well I tried with single element and with Base structure data and then I get the error that:
Details: “5 arguments were passed to a function which expects between 3 and 4.”
attaching a short clip!