Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a Stored Procedure from SQL Server that uses a CTE to insert rows into a Data warehouse table that I want to replicate in Microsoft Fabric.
I keep on getting errors that into statement is not supported.
Solved! Go to Solution.
Now it works. Did you do anything? Thank you anyway.
Hello @cubansalsa ,
Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.
Hi @cubansalsa ,
Can you please confirm above SQL is complete SQL query? As there is nothing in the SQL code that looks problematic and there is no INSERT statement.
It is correct. Just replace the las select * with select * into.
or try to use any into stament and you will get the error.
thank you for looking into this problem.
Hi @cubansalsa ,
When I tried to repro your scenario, I didn't face any issue.
I was able to run the query in Data Warehouse without any issues.
Can you please share the screenshot of your issue?
Now it works. Did you do anything? Thank you anyway.
Hi @cubansalsa ,
It might be an Intermittent issue, glad to know that your issue got resolved. Please continue using Fabric Community on your further queries.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the March 2024 Fabric update to learn about new features.
User | Count |
---|---|
8 | |
7 | |
6 | |
4 | |
4 |