Forum Discussion
[SQL database in Fabric] Saved queries not listed in "My queries" in the query editor (auto-save suc
Product: SQL database in Fabric (NOT Azure SQL Database, NOT Fabric Warehouse)
In the query editor of a SQL database in Fabric item, saved queries do
not appear under Explorer > Queries > My queries.
The queries ARE being saved. Evidence:
- New query names keep incrementing (currently at "SQL query 10")
- Saving with an existing query name returns a duplicate name error
So this is a display/listing issue, not a save failure.
Already ruled out:
- Cache / cookies / extensions: reproduced in an InPrivate window
- Account or profile mismatch: same work account throughout,
never switched browser profiles
- Environment-wide problem: in the SAME workspace, the SQL analytics
endpoint of a lakehouse lists its saved queries under "My queries"
correctly. Only the SQL database in Fabric item is affected.
Docs for the SQL database in Fabric query editor state that queries are
automatically saved every few seconds, with a "saving" indicator in the
query tab. The save behavior matches the docs - only the listing is missing.
https://learn.microsoft.com/en-us/fabric/database/sql/query-editor
Environment:
- Item type: SQL database in Fabric
- Region: Southeast Asia
- Capacity: F8
I checked Known Issues (Databases category) and found no matching entry.
Has anyone else seen this with SQL database in Fabric?
2 Replies
- v-sathmakuriCommunity Support
Hi Yas50 ,
Thank you for reaching out to fabric community.
Verify whether the issue occurs in a new SQL database and for another user with the same permissions. If the issue persists, open a Microsoft Support ticket (https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket).
Thanks!! - ShivekMaharajImpactful Individual
Hi Yas50 ,
Based on the evidence you shared, the queries appear to be saving successfully. The strongest clue is that each query remains accessible through its direct URL. That means the query object still exists; the failure seems limited to Explorer → Queries → My queries not listing it.
Microsoft’s documentation states that SQL database queries are automatically saved and that saved queries should appear in the Explorer. Your result therefore looks inconsistent with the documented behaviour.
I would treat this as a likely query-listing or metadata-indexing issue, rather than an autosave problem.
You have already ruled out the main browser-side causes by testing another browser, an InPrivate session, the same account and workspace, and refreshing the page. I would not spend more time repeating those checks.
The best next step is to report it through the query editor’s Feedback option and open a Fabric support case.
I would include:
- the workspace ID,
- the SQL database item ID,
- the capacity and region,
- one affected query URL,
- the approximate time the query was created,
- a screenshot showing the query open successfully,
- a screenshot showing that it is missing from My queries,
- confirmation that the issue persists in another browser and InPrivate mode.
Until Microsoft confirms the cause, I would keep important SQL scripts in source control, SSMS or VS Code as a precaution.
In summary, the queries do not appear to be lost. They appear to be saved but not surfaced correctly in the My queries listing.