Forum Discussion
Power Bi and Nosql database
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?
Super UserAnonymous , 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?