Temp Table using Direct Query

[johnsiah91]

Hi,

I was able to bring in data to PBI Desktop using temp tables but I get an "Incorrect Syntax Error" now when I try it now. Did something change? 

I did a couple of test of my end:

1. I tried to use the SQL code (has temp tables) that is already in PBI Desktop and tried to import it and I am getting the error now.

2. I compared the old code and new code but did not see any differences.

p.s I am not allow to create a view or stored procedure due to a contract agreement with the data company.

[amitchandak]

@johnsiah91 , Try if you can use a query with "with" clause.

[johnsiah91]

With statements give me the same error message. As of now, the only workaround I have is to put everything into a nested statement.