Forum Discussion

khanjaved's avatar
khanjaved
Icon for Microsoft Employee rankMicrosoft Employee
6 months ago

T‑SQL Magic Command (%%tsql) Error in Microsoft Fabric Notebook on Fabric SQL Database

Hello, My T-SQL command executed from a Microsoft Fabric Python notebook against a Fabric SQL Database was working fine last week, but it has suddenly stopped working. There is no change from our ...
workspaces
khanjaved's avatar
khanjaved
Icon for Microsoft Employee rankMicrosoft Employee
6 months ago

Hi AsgerLB , Tried both the way, still not working.

  • khanjaved's avatar
    khanjaved
    Icon for Microsoft Employee rankMicrosoft Employee
    6 months ago

    AsgerLBYes I tried, And I think with the session you can run the %tsql magic cmd in the next cell, alone with %%tsql look like its not going to be helpful.

    • AsgerLB's avatar
      AsgerLB
      Icon for Resolver I rankResolver I
      6 months ago

      khanjaved , so you can make it work by using the -session parameter in one cell and then making your query in a new %%tsql command?

      • khanjaved's avatar
        khanjaved
        Icon for Microsoft Employee rankMicrosoft Employee
        6 months ago

        AsgerLB How it will work? for session we need to use -artifact -type cmd which itself is not working for me now. which is the main issue I posted.