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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.