<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Fabric Data Warehouse git update issue with correct stored procedures in Data Warehouse</title>
    <link>https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-Data-Warehouse-git-update-issue-with-correct-stored/m-p/4920501#M4113</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1244436" data-lia-user-login="RehanH14" class="lia-mention lia-mention-user"&gt;RehanH14&lt;/a&gt;&amp;nbsp;,&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;
&lt;P&gt;This behavior is expected as Fabric Warehouse Git integration is currently in preview. Please wait for a fix in upcoming releases.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Best Regards,&amp;nbsp;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Community Support Team.&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Mon, 19 Jan 2026 07:00:04 GMT</pubDate>
    <dc:creator>v-menakakota</dc:creator>
    <dc:date>2026-01-19T07:00:04Z</dc:date>
    <item>
      <title>Fabric Data Warehouse git update issue with correct stored procedures</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-Data-Warehouse-git-update-issue-with-correct-stored/m-p/4915394#M4077</link>
      <description>&lt;DIV&gt;&lt;P&gt;We’re seeing a repeatable issue with &lt;STRONG&gt;Fabric Warehouse + Git integration&lt;/STRONG&gt; that appears to be a &lt;STRONG&gt;deployment bug&lt;/STRONG&gt;, not an actual SQL problem.&lt;/P&gt;&lt;H3&gt;&lt;STRONG&gt;Scenario&lt;/STRONG&gt;&lt;/H3&gt;&lt;UL&gt;&lt;LI&gt;We have a &lt;STRONG&gt;Git-enabled Fabric workspace&lt;/STRONG&gt; with a &lt;STRONG&gt;Warehouse&lt;/STRONG&gt;.&lt;/LI&gt;&lt;LI&gt;The Warehouse contains a &lt;STRONG&gt;stored procedure&lt;/STRONG&gt;.&lt;/LI&gt;&lt;LI&gt;The stored procedure:&lt;UL&gt;&lt;LI&gt;Compiles successfully&lt;/LI&gt;&lt;LI&gt;Executes successfully&lt;/LI&gt;&lt;LI&gt;Has been tested and works as expected&lt;/LI&gt;&lt;/UL&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;H3&gt;&lt;STRONG&gt;Steps&lt;/STRONG&gt;&lt;/H3&gt;&lt;OL&gt;&lt;LI&gt;Create/update a stored procedure in the Warehouse.&lt;/LI&gt;&lt;LI&gt;Commit changes to Git.&lt;/LI&gt;&lt;LI&gt;Create a PR and merge into &lt;STRONG&gt;main&lt;/STRONG&gt; (merge succeeds).&lt;/LI&gt;&lt;LI&gt;Go back to the workspace attached to &lt;STRONG&gt;main&lt;/STRONG&gt;.&lt;/LI&gt;&lt;LI&gt;Select &lt;STRONG&gt;“Update from Git”&lt;/STRONG&gt;.&lt;/LI&gt;&lt;/OL&gt;&lt;H3&gt;&lt;STRONG&gt;Issue&lt;/STRONG&gt;&lt;/H3&gt;&lt;P&gt;During &lt;STRONG&gt;Update from Git&lt;/STRONG&gt;, the workspace update &lt;STRONG&gt;fails&lt;/STRONG&gt; with a &lt;STRONG&gt;SQL syntax error on the stored procedure&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;However:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;The exact same stored procedure &lt;STRONG&gt;runs fine&lt;/STRONG&gt; when:&lt;UL&gt;&lt;LI&gt;Executed manually&lt;/LI&gt;&lt;LI&gt;Created in another workspace&lt;/LI&gt;&lt;LI&gt;Dropped and recreated manually&lt;/LI&gt;&lt;/UL&gt;&lt;/LI&gt;&lt;LI&gt;The error &lt;STRONG&gt;only happens during Git sync&lt;/STRONG&gt;&lt;/LI&gt;&lt;LI&gt;The syntax error is inconsistent / misleading&lt;/LI&gt;&lt;LI&gt;Manually opening the SP and clicking &lt;STRONG&gt;Save&lt;/STRONG&gt; (without changes) allows it to work again&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;This strongly suggests the issue lies in the &lt;STRONG&gt;Git → Warehouse publish process&lt;/STRONG&gt;, not in the SQL itself.&lt;/P&gt;&lt;H3&gt;&amp;nbsp;&lt;/H3&gt;&lt;H3&gt;&lt;STRONG&gt;Expected Behaviour&lt;/STRONG&gt;&lt;/H3&gt;&lt;UL&gt;&lt;LI&gt;Workspace should update cleanly from Git&lt;/LI&gt;&lt;LI&gt;Stored procedure should deploy as committed&lt;/LI&gt;&lt;LI&gt;No syntax error should be raised for valid SQL&lt;/LI&gt;&lt;/UL&gt;&lt;H3&gt;&lt;STRONG&gt;Question&lt;/STRONG&gt;&lt;/H3&gt;&lt;UL&gt;&lt;LI&gt;Is this a &lt;STRONG&gt;known issue&lt;/STRONG&gt; with Fabric Warehouse Git integration?&lt;/LI&gt;&lt;LI&gt;Are there known limitations or required patterns for stored procedure deployment (e.g. DROP + CREATE vs CREATE OR ALTER)?&lt;/LI&gt;&lt;LI&gt;Is there a recommended workaround until this is fixed?&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Happy to provide logs, screenshots, or the full error trace if needed.&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;&lt;/DIV&gt;</description>
      <pubDate>Fri, 09 Jan 2026 11:46:12 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-Data-Warehouse-git-update-issue-with-correct-stored/m-p/4915394#M4077</guid>
      <dc:creator>RehanH14</dc:creator>
      <dc:date>2026-01-09T11:46:12Z</dc:date>
    </item>
    <item>
      <title>Re: Fabric Data Warehouse git update issue with correct stored procedures</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-Data-Warehouse-git-update-issue-with-correct-stored/m-p/4915731#M4082</link>
      <description>&lt;P&gt;hi&amp;nbsp;&lt;a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1244436" data-lia-user-login="RehanH14" class="lia-mention lia-mention-user"&gt;RehanH14&lt;/a&gt;&amp;nbsp;,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Yes — this appears to be a &lt;STRONG&gt;known limitation&lt;/STRONG&gt; in the current Git integration for &lt;STRONG&gt;Fabric Data Warehouse&lt;/STRONG&gt;, which is still in &lt;STRONG&gt;preview&lt;/STRONG&gt;.&lt;/P&gt;&lt;H3&gt;What’s happening?&lt;/H3&gt;&lt;UL&gt;&lt;LI&gt;&lt;P&gt;During &lt;STRONG&gt;Update from Git&lt;/STRONG&gt;, Fabric attempts to re-deploy the stored procedure via SQL project logic.&lt;/P&gt;&lt;/LI&gt;&lt;LI&gt;&lt;P&gt;This sometimes leads to &lt;STRONG&gt;false syntax errors&lt;/STRONG&gt;, even if the procedure runs fine manually or in other workspaces.&lt;/P&gt;&lt;/LI&gt;&lt;LI&gt;&lt;P&gt;Simply opening the procedure in Fabric and clicking &lt;STRONG&gt;Save&lt;/STRONG&gt; often resolves it — confirming it's a deployment issue, not SQL syntax.&lt;/P&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;H3&gt;Known Issues (based on community + Microsoft docs):&lt;/H3&gt;&lt;UL&gt;&lt;LI&gt;&lt;P&gt;Git + Warehouse sync can &lt;STRONG&gt;fail inconsistently&lt;/STRONG&gt;, especially with stored procedures.&lt;/P&gt;&lt;/LI&gt;&lt;LI&gt;&lt;P&gt;Microsoft documentation confirms that Git support is &lt;STRONG&gt;still evolving&lt;/STRONG&gt;, with limitations around SQL object deployment.&lt;/P&gt;&lt;/LI&gt;&lt;LI&gt;&lt;P&gt;Common issue threads: &lt;A href="https://community.fabric.microsoft.com/t5/Data-Engineering/Git-error-with-Warehouse/m-p/4656783?utm_source=chatgpt.com" target="_new" rel="noopener"&gt;Example&lt;/A&gt;&lt;/P&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;H3&gt;Workarounds &amp;amp; Best Practices:&lt;/H3&gt;&lt;UL&gt;&lt;LI&gt;&lt;P&gt;Use CREATE OR ALTER PROCEDURE instead of CREATE alone — it's more reliable during deployment.&lt;/P&gt;&lt;/LI&gt;&lt;LI&gt;&lt;P&gt;Keep stored procedures &lt;STRONG&gt;modular and simple&lt;/STRONG&gt; where possible.&lt;/P&gt;&lt;/LI&gt;&lt;LI&gt;&lt;P&gt;Use &lt;STRONG&gt;deployment pipelines or SQL projects&lt;/STRONG&gt; for production-grade rollouts.&lt;/P&gt;&lt;/LI&gt;&lt;LI&gt;&lt;P&gt;Treat &lt;STRONG&gt;Update from Git&lt;/STRONG&gt; as less predictable for complex SQL objects during preview.&lt;/P&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;If this post helps, then please appreciate giving a &lt;STRONG&gt;Kudos&lt;/STRONG&gt; or accepting as a &lt;STRONG&gt;Solution&lt;/STRONG&gt; to help the other members find it more quickly.&lt;BR /&gt;If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!&lt;/P&gt;</description>
      <pubDate>Fri, 09 Jan 2026 23:13:54 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-Data-Warehouse-git-update-issue-with-correct-stored/m-p/4915731#M4082</guid>
      <dc:creator>ssrithar</dc:creator>
      <dc:date>2026-01-09T23:13:54Z</dc:date>
    </item>
    <item>
      <title>Re: Fabric Data Warehouse git update issue with correct stored procedures</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-Data-Warehouse-git-update-issue-with-correct-stored/m-p/4916525#M4094</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1244436" data-lia-user-login="RehanH14" class="lia-mention lia-mention-user"&gt;RehanH14&lt;/a&gt;&amp;nbsp;,&lt;BR /&gt;Thanks for reaching out to the Microsoft fabric community forum.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I would also take a moment to thank &lt;a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1448111" data-lia-user-login="ssrithar" class="lia-mention lia-mention-user"&gt;ssrithar&lt;/a&gt;&amp;nbsp;  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;
&lt;P&gt;Yes, this aligns with current Fabric Warehouse Git limitations. Since Git integration is still in preview, stored procedures can fail during Update from Git even when the SQL itself is valid. The fact that saving the procedure manually resolves the issue strongly suggests a deployment problem rather than a syntax issue.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Best Regards,&amp;nbsp;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Community Support Team&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 12 Jan 2026 09:04:26 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-Data-Warehouse-git-update-issue-with-correct-stored/m-p/4916525#M4094</guid>
      <dc:creator>v-menakakota</dc:creator>
      <dc:date>2026-01-12T09:04:26Z</dc:date>
    </item>
    <item>
      <title>Re: Fabric Data Warehouse git update issue with correct stored procedures</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-Data-Warehouse-git-update-issue-with-correct-stored/m-p/4920501#M4113</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1244436" data-lia-user-login="RehanH14" class="lia-mention lia-mention-user"&gt;RehanH14&lt;/a&gt;&amp;nbsp;,&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;
&lt;P&gt;This behavior is expected as Fabric Warehouse Git integration is currently in preview. Please wait for a fix in upcoming releases.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Best Regards,&amp;nbsp;&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;Community Support Team.&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 19 Jan 2026 07:00:04 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Warehouse/Fabric-Data-Warehouse-git-update-issue-with-correct-stored/m-p/4920501#M4113</guid>
      <dc:creator>v-menakakota</dc:creator>
      <dc:date>2026-01-19T07:00:04Z</dc:date>
    </item>
  </channel>
</rss>

