Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |