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
AsgerLB's avatar
AsgerLB
Icon for Resolver I rankResolver 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
Icon for Microsoft Employee rankMicrosoft Employee
6 months ago

AsgerLB  Yes not working.

  • khanjaved's avatar
    khanjaved
    Icon for Microsoft Employee rankMicrosoft 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.

  • AsgerLB's avatar
    AsgerLB
    Icon for Resolver I rankResolver 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
    Icon for Microsoft Employee rankMicrosoft Employee
    6 months ago

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