Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
RussGriff
Frequent Visitor

Gateway Advanced Logging ?

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

1 ACCEPTED 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 🙂

 

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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 🙂

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.