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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
konradjonsson
Helper II
Helper II

OLE DB or ODBC error incorrect syntax near the keyword 'union'

Hi.

 

I have a problem when I try to append two queries.

The queries I am trying to append are retreiving data from an SQL server (same server, same database, same table).

 

The error message is:

OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Incorrect syntax near the keyword 'union'.. '.

 

I have seen earlier posts on the same topic, but I have not seen (or understood) what the solution is.

One control question made by a community member was; "Did you happen to use a native query when you connected to your data source?" (I do not know what a native query is, or what other queries there are)

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

Hi  @konradjonsson ,

 

Native query refers to actual sql queries (referring to actual database objects). These queries are the sql statements which can be directly executed in database using a database client.

Check similar thread below to solve your issue:

https://community.powerbi.com/t5/Service/Microsoft-SQL-Incorrect-syntax-near-the-keyword-union-Table...

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

View solution in original post

4 REPLIES 4
v-kelly-msft
Community Support
Community Support

Hi  @konradjonsson ,

 

Native query refers to actual sql queries (referring to actual database objects). These queries are the sql statements which can be directly executed in database using a database client.

Check similar thread below to solve your issue:

https://community.powerbi.com/t5/Service/Microsoft-SQL-Incorrect-syntax-near-the-keyword-union-Table...

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Thanks! The link you provided showed a solution that included removing the 'sorted rows'-step. I removed the sorted rows and then it worked.

Hi Kelly.

Thanks. The native query aspect mentioned was only to highlight that I had seen that comment in earlier questions on the error. I have now also understood that I am not using native queries.

 

What I need help with is to understand why I get the error when trying to append two other queries.

Hi  @konradjonsson ,

 

Sometimes the error happens when the transformations in previous steps are not allowed or there are some conflicts between transformations.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors
Top Kudoed Authors