Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to Solution.
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?
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
@k_yadu , Once you import the data you use merge operation
: https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Hi @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?
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
100 | |
97 | |
88 | |
68 |
User | Count |
---|---|
173 | |
134 | |
132 | |
103 | |
95 |