March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I have enabled advanced logging on one of our gateways as I want to be able to get the associated dataset id for a refresh. However, I am not seeing the extra details in the QueryExecution or QueryStart logs.
Is there a separate log or should this detail appear in those existing logs ? It's a new gateway with not much traffic and logs haven't switched yet - any ideas when/where I'll see those extra details ?
Thanks
Solved! Go to Solution.
Actually - I think I may have found those messages now in the
- GatewayInfo20220825.000000147.log
I was expecting to see it in the QueryStart/Execution logs
I'll dig a bit deeper but I may have answered my own question 🙂
Hi @RussGriff
As far as I understand the Gatway logs will log when there are refreshes or directQuery happening via the gateway. In terms of Query stats I do not think that would be in the Gateway logs.
Here are more details that might assist you with logging from the Gateway: Monitor and optimize on-premises data gateway performance | Microsoft Docs
In the link you provided it states :
When you turn on this setting, you can see additional information (application context in the following sample) in the gateway logs that indicates which dataset or report this query belongs to. Not all services are able to send this information at this time and we are working on known gaps.
QueryAdditionalInformation is: { "Application": "Dataset-Premium", "ObjectId": "6de5b524-8a04-4578-961d-e65b2bf3dcd4", "ApplicationContext": "{\"DatasetId\":\"6de5b524-8a04-4578-961d-ej67gdf3dcd4\",\"Sources\":[{\"ReportId\":\"e0cec7bc-f53d-4174-b551-678656fba\"}]}" }.
But I am not seeing any of this information in the logs for refreshes - or I am looking in the wrong place
Actually - I think I may have found those messages now in the
- GatewayInfo20220825.000000147.log
I was expecting to see it in the QueryStart/Execution logs
I'll dig a bit deeper but I may have answered my own question 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
37 | |
22 | |
20 | |
10 | |
9 |
User | Count |
---|---|
60 | |
56 | |
22 | |
14 | |
12 |