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.
Go to Solution.
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
Please check the SQL query of the datasets and overwrite your Datasource for the report in Power BI Service if required.
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.
Have you checked in your filters/Transformations applied in the datasets?
Good. Appending two tables is being part of Transformations of Power BI.
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.