Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register 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 🙂
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 31 | |
| 30 | |
| 21 | |
| 16 | |
| 16 |