Forum Discussion
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
Have you checked in your filters/Transformations applied in the datasets?
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
Good. Appending two tables is being part of Transformations of Power BI.