Forum Discussion
Power Bi and Nosql database
Hello All, I am working on integration of Power BI with Apache Cassandra. The challenge which i am facing is joining 2 tables on Power BI after connecting it to Cassandra. It is giving "Unsuppo...
It's a long shot but can you try adding a Table.Buffer(previousStepName) to the step immediately before the merge to see if you get any different results?
Merge Query Error for Cassandra DB TablesHi amitchandak .....Thanks for the reply.
I am using Cassandra database and it is a NOSQL database i.e. No joins supported.
After using the merge option,If I expand the merged table and click on apply, I am getting "Unsupported Query" error.
Is there any way to transform data for a database which doesn't support joins.
It's a long shot but can you try adding a Table.Buffer(previousStepName) to the step immediately before the merge to see if you get any different results?