One of the great things about Neo4j is the use of Cypher over SQL. In the presentations and sales pitches, I have seen, there are many examples of how neo4j is able to take a complex a SQL query that is pages long and condense using cypher. So why do we have to now use SQL in PowerBI and build those complex queries? Is this a Microsoft limitation? Is neo4j planning on building an actual connector that you can use cypher for or is it recommended to use the REST API to use cypher?
1 Like
Have you tried the connector at Github - this uses Cypher - but yes - has to be over the REST API.
Custom connectors for PowerBI don't allow you to use anything other than M to write code (unless that has changed recently) so it's kind of restricted that way.
Yeah we tried that were unable to get it to work with our instance for some reason. We ended using the REST API and it is responsive enough and lets us use Cypher so works for our use case