Forum Discussion
Helper IIIFabricLakehouseQueryLogs
How to enable FabricLakehouseQueryLogs?
execute queries via a Fabric lakehouse SQL endpoint
Want to log such queries about workspace, lakehouse, the number of queries, query duration
Use Trial and F64
Workspace Setting -> Monitoring
Fabric Admin Portal -> Tenant Settings
But there is no setting about FabricLakehouseQueryLogs????
Hi yongshao ,
Thanks for reaching out to the Microsoft Fabric Community.
At the moment, there doesn’t appear to be a setting called FabricLakehouseQueryLogs under Workspace Monitoring or the Fabric Admin Portal > Tenant Settings.
However, there are a few options that might help track Lakehouse SQL query activity.
You can try setting up diagnostic settings on your Lakehouse in the Azure portal to send logs to Log Analytics. If logs are flowing correctly, you might be able to run KQL queries in Log Analytics to view query activity.
For more details, please visit this link: Solved: Re: Lakehouse End User Usage - Microsoft Fabric Community
Also, if you go to the Lakehouse SQL endpoint and click the three dots, there should be an option called Query Activity. That view shows details like the query text, submit time, duration, status, submitter, session ID, and run source.You could also check if the Fabric Capacity Metrics app gives some of the usage insights you're looking for.
Some useful links:
Monitor a data warehouse in Microsoft Fabric | mslearn-fabric
Solved: Re: Lakehouse End User Usage - Microsoft Fabric Community
Hope this helps. Please reach out for further assistance.
Thank you.
6 Replies
- Vinodh247
Super User
There is currently no direct FabricLakehouseQueryLogs toggle or built-in setting under Workspace Monitoring or Admin Portal --> Tenant Settings, even with the Trial/F64 SKUs.
What is Actually Available in Fabric Today?
Query history > user level:
You can view recent queries executed on a Lakehouse SQL endpoint via:
Lakehouse -> Open the SQL endpoint -> History tab
This shows basic metadata:
Query text
User related
Start time & the duration
Status (success/failed)
Activity logs > Fabric wide:
Go to Microsoft Fabric Admin Portal -> Monitoring -> Activity log
But: These logs currently do not include Lakehouse SQL endpoint queries. They mostly log changes to resources (creation/deletion etc.)
Workarounds that youcan try:
Use Lakehouse SQL endpoint query history manually
Each lakehouse has its own SQL history.
But this does not scale across multiple workspaces or users.
Enable Microsoft Purview or Microsoft 365 audit logs
If Microsoft 365 auditing is enabled, and your organization uses Purview, some Power BI-level interactions are logged.
However, Lakehouse SQL queries are not currently part of this logging stream.
Use custom telemetry
Add a wrapper to client-side tools (e.g., Azure Data Studio, notebooks) that captures query metrics and logs them to Log Analytics or a custom table.
Requires effort and cannot capture queries made via the UI directly.
Since you are on a Trial with F64 capacity, you do wont be having access to the full fabric logs via log analytics or diagnostic settings, as i believe they are available only in paid premium capacities (typically F128 and above, or PBI premium capacities).
Please 'Kudos' and 'Accept as Solution' if this answered your query.
yongshaoThanks, we also tried with paid F64
v-veshwara-msftCommunity Support
Hi yongshao ,
Thanks for reaching out to the Microsoft Fabric Community.
At the moment, there doesn’t appear to be a setting called FabricLakehouseQueryLogs under Workspace Monitoring or the Fabric Admin Portal > Tenant Settings.
However, there are a few options that might help track Lakehouse SQL query activity.
You can try setting up diagnostic settings on your Lakehouse in the Azure portal to send logs to Log Analytics. If logs are flowing correctly, you might be able to run KQL queries in Log Analytics to view query activity.
For more details, please visit this link: Solved: Re: Lakehouse End User Usage - Microsoft Fabric Community
Also, if you go to the Lakehouse SQL endpoint and click the three dots, there should be an option called Query Activity. That view shows details like the query text, submit time, duration, status, submitter, session ID, and run source.You could also check if the Fabric Capacity Metrics app gives some of the usage insights you're looking for.
Some useful links:
Monitor a data warehouse in Microsoft Fabric | mslearn-fabric
Solved: Re: Lakehouse End User Usage - Microsoft Fabric Community
Hope this helps. Please reach out for further assistance.
Thank you.
- v-veshwara-msft
Hi yongshao ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.
- v-veshwara-msft
Hi yongshao ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you. - v-veshwara-msft
Hi yongshao ,
Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.Thank you.
