Query Editor fails to load data model

[lt79_Pax]

The Power BI Query Editor fails to load the data model eventhough the SQL  queries scripting each table displays successfully.  When I click on the close and apply, it tells me there is a syntax error eventhough in the query editor mode the queries outputs are successfully displayed.  I do not understand what I am doing wrong.  Please advise.

[Cmcmahan]

Is there any more specific information on the syntax error you're receiving?

If you could share screenshots of the error, we could help more, but there are TONS of different things that could cause a syntax error in the query editor and prevent you from importing. 

[lt79_Pax]

Once I try to close and load the data tables I receive these error messages eventhough Query Editor displays each table successfully prior.  

---

Apply query changes
table1
Microsoft SQL: Incorrect syntax near the keyword 'create'.
 Incorrect syntax near ')'.
table2
Microsoft SQL: Incorrect syntax near the keyword 'if'.
 Incorrect syntax near ')'.
table3
Microsoft SQL: Incorrect syntax near the keyword 'if'.
 Incorrect syntax near ')'.

[Cmcmahan]

Sounds like you have some incorrect syntax around your table SQL queries.  Can you share the offending sql syntax?  Looks like you've misplaced a semicolon or parens somewhere.