March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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! |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
125 | |
85 | |
69 | |
54 | |
45 |
User | Count |
---|---|
204 | |
105 | |
98 | |
65 | |
54 |