Do anyone use know how to connect Power BI with Neo4j? We mostly use Power Bi as reporting tool for our team and would like to understand if there are any connectivity option to Power BI.
If not available, then Is there any good visualization tools available in the market for data analysis from Neo4J database?
Solved! Go to Solution.
Hey, I've been trying to accomplish what is written in that link, but I cant seem to do it.
After I log in with my username and password to the local database, I get the following error:
I followed everything step by step, even using the :play movies database.
Anyone got an idea what's wrong?
I'm pretty sure the issue here is that the
4.0 release of Neo4j has a different Transaction endpoint than the
4.0 MR2 version - I either need a
3.x version - or work out how to allow you to switch between the two -
I'm away at the moment, so it'll be slow going but I'll have a look later on if I can.
Yes, it's the PowerBI connector from https://github.com/cskardon/Neo4jDataConnectorForPowerBi/ .
Here are my proposed updates:
As an example, here's how Power BI accepts SQL queries:
Is there any way to establish a data pipeline so that data can be ingested automatically from Neo4j into PowerBI? Can this connector integrate with the upcoming release of Apache Hop? I think that would be useful.
Auto Refresh. I see that this has been already proposed under the Issues section in the githun repo but it's related to number 2 above.
Lastly, I began to notice that I now get this error message, even for simple queries like MATCH(p:Person) RETURN p.name LIMIT 100. Not sure exactly what is triggering this error but I didn't have this error message when I began to use this PowerBI connector back in July. After I export and inspect the cypher output as a csv and json, I don't see any extra characters at the end of the JSON input.
What could be causing this error?
(1) Yes, I would love to get the Cypher field to be bigger - I've yet to work out how to do that, the docs for developing things like this are not what I would call detailed. I'll try to remember to put this into GH as an issue.
(2/3) - These are pain areas, I've tried many times and as far as I know - I've done what I should do to get this to work, but I'm not a PowerBI expert so I don't know if it's not working because my setup is wrong, or because the connector isn't working (I mean I'm reasonably confident it's the latter)
Error message: Errr, I don't know - it's over REST, so something like Fiddler might be of use to show exactly what is being sent - if you could put that into a GH I will look and see if I can replicate. Have you changed version of Neo4j? Query? - It's not an error message I've written, so I presume it's from the tools used by PowerBI, but I might be able to see
All the best
OK, now I don't get the error message - there were a couple of PowerBI Desktop updates over Christmas, it's possible they rectified it - but @TonyOD27 - if you can let me know the exact version of Neo4j you're using - and an example query I can have a look into it -
Issues on GH would be cool too 🙂
Thank you @charlotte.skardon !
This latest version of the PowerBI connector is working well. I'm not getting any more error messages for now and having the Multi-Line for Cypher is a nice GUI improvement.
I'm using version 4.2.0 of the community edition on a CentOS 7 virtual machine. Here are our specs:
36GB of ram in the VM with 8 CPU. Storage is 25GB.
I'm working on passing longer Cypher queries to the connector and I'll post on this thread or a GH Issue if I have any more problems or suggestions.
By the way, I watched this video (Why Your BI Users Need Access to Graph Data Insights | Neo4j BI Connector - YouTube) on the Neo4j BI connector. At the 15:48 mark, the presenter mentions that BI support for PowerBI is coming.
Out of curiosity, do you know if the BI connector will replace your connector? Or will there be a merger of the two? What is the status on the addition of PowerBI to the Neo4j BI connector?
Well, we're getting there @TonyOD27
Please use GH - as that way I can fix / work on things that are marked - but also it means someone else might 🙂
OK, I'll first talk about the BI Connector for PowerBI - Mine will probably always work / exist - I believe the aim is to have a BI connector equivalent to the JDBC one they have at the moment (so an ODBC based one), I mean another way to use PowerBI is with an ODBC-JDBC bridge as well. In terms of 'replacing' mine - not in that way - I suspect mine will fall out of use 🙂 but it'll be there as a connector as long as GitHub exists.