Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@johnsiah91 , Try if you can use a query with "with" clause.
With statements give me the same error message. As of now, the only workaround I have is to put everything into a nested statement.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |