cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amjedashraf Frequent Visitor
Frequent Visitor

Microsoft SQL: Incorrect syntax near the keyword 'union'. Table: SalesFact.

Hi All,

 

Can anyone help me with this error. When i refresh data set in powerbi service it give me this error.

 

Microsoft SQL: Incorrect syntax near the keyword 'union'. Table: SalesFact.

 

Where as in powerbi desktop the table is getting refreshed.

1 ACCEPTED SOLUTION

Accepted Solutions
amjedashraf Frequent Visitor
Frequent Visitor

Re: Microsoft SQL: Incorrect syntax near the keyword 'union'. Table: SalesFact.

 

Hi All,

 

i got the solution to this error, it was append query which was making the error. I was appending some data from another table. 

 

if anyone face this error in future always look for append in your query in your table just delete it this error will be resolved.

 

The append query was working fine but maybe now the data has increased in the table so it was not working fine. Thanks

 

View solution in original post

5 REPLIES 5
Pauwnrajpp Member
Member

Re: Microsoft SQL: Incorrect syntax near the keyword 'union'. Table: SalesFact.

Hi amjedashraf,

 

Please check the SQL query of the datasets and overwrite your Datasource for the report in Power BI Service if required.

 

 

Regards,

Pradeep

amjedashraf Frequent Visitor
Frequent Visitor

Re: Microsoft SQL: Incorrect syntax near the keyword 'union'. Table: SalesFact.

Hi Pauwn,

 

I have checked the query, in the query editor there is no word like union in the query and there is no syntax error in the query editor. 

 

Dont know what is happening.  

Pauwnrajpp Member
Member

Re: Microsoft SQL: Incorrect syntax near the keyword 'union'. Table: SalesFact.

Have you checked in your filters/Transformations applied in the datasets?

amjedashraf Frequent Visitor
Frequent Visitor

Re: Microsoft SQL: Incorrect syntax near the keyword 'union'. Table: SalesFact.

 

Hi All,

 

i got the solution to this error, it was append query which was making the error. I was appending some data from another table. 

 

if anyone face this error in future always look for append in your query in your table just delete it this error will be resolved.

 

The append query was working fine but maybe now the data has increased in the table so it was not working fine. Thanks

 

View solution in original post

Pauwnrajpp Member
Member

Re: Microsoft SQL: Incorrect syntax near the keyword 'union'. Table: SalesFact.

Good. Appending two tables is being part of Transformations of Power BI.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 39 members 1,890 guests
Please welcome our newest community members: