Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
k_yadu
New Member

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

1 ACCEPTED 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 ;).
chrome-9xf-Zagzel-B

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.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x

View solution in original post

3 REPLIES 3
amitchandak
Super User
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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Merge Query Error for Cassandra DB TablesMerge 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?

 

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 ;).
chrome-9xf-Zagzel-B

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.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.