Forum Discussion

khanjaved's avatar
khanjaved
Microsoft 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
Microsoft 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.

AsgerLB's avatar
AsgerLB
Resolver I
6 months ago

khanjaved so running this 

 

%%tsql -artifact sqldb1 -type SQLDatabase -session
SELECT TOP (10) * FROM [SalesLT].[Address]

Does not work?

  • khanjaved's avatar
    khanjaved
    Microsoft Employee
    6 months ago

    AsgerLB Fyi.. Tried one more thing, we have two tenant in other tenant its working fine, now need to see what need be fixed in the tenant where query is not working.

  • khanjaved's avatar
    khanjaved
    Microsoft Employee
    6 months ago

    AsgerLB  Yes not working.

  • AsgerLB's avatar
    AsgerLB
    Resolver I
    6 months ago

    khanjaved  thanks for confirming.

    I'm capable of querying my SQL database called TranslyticalDemo with a python notebook (ver 3.11) all placed in the same workspace via the following code:

    %%tsql -artifact TranslyticalDemo -type SQLDatabase -session
SELECT * FROM [SalesLT].[Sales]

     

    Can you confirm that you are using a Python execution engine for your notebook and which version, and that both items are in the same workspace?

    Also what happens if you create a new python notebook in the workspace of your sqldb and run the code?

  • khanjaved's avatar
    khanjaved
    Microsoft Employee
    6 months ago

    AsgerLB Now I have created a new workspace, db and notebook on trial capacity, but still getting the same error.