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 "Unsupported Query" error.
Is there any way to perform join operation on tables in Power BI for Cassandra or any NoSQL database.
Thanks
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?
3 Replies
- amitchandak
Super User
Anonymous , Once you import the data you use merge operation
: https://radacad.com/append-vs-merge-in-power-bi-and-power-query
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.
- KNP
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?
