Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Performance Issue in Service

Team,   As we know we have lot of good tools to check the performance in Power BI Desktop like performance analyzer or Dax studio, I would like to know how to track or check the performance in Powe...
Need Help
Tips and Tricks
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    Based on this document: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance#slow-performing-queries

     

    By default, the gateway performs basic logging. If you're investigating slow-performing queries, in addition to using the performance monitoring feature, you can temporarily enable Additional logging to gather additional log information. To do this, in the on-premises data gateway app select Diagnostics > Additional logging.

     

    Enabling this setting likely will increase the log size significantly, based on gateway usage. We recommend that after you finish reviewing the logs that you disable additional logging. We don't recommend leaving this setting enabled during normal gateway usage.

     

     


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

If you are looking for a tools to analysis the issue about measures and visuals, we suggest to download pbix file from power bi service and use Dax Studio or Performance Analyzer to analysis them in Power BI Service. If you want to analysis the reason about long refreshing duration in Power BI Service, we can use the additional log of On-Premises Data Gateway to analysis the issue query.


Best regards,

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-lid-msft How to use additional log of on prem gateway to check the issue with regresh? 

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Based on this document: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance#slow-performing-queries

     

    By default, the gateway performs basic logging. If you're investigating slow-performing queries, in addition to using the performance monitoring feature, you can temporarily enable Additional logging to gather additional log information. To do this, in the on-premises data gateway app select Diagnostics > Additional logging.

     

    Enabling this setting likely will increase the log size significantly, based on gateway usage. We recommend that after you finish reviewing the logs that you disable additional logging. We don't recommend leaving this setting enabled during normal gateway usage.

     

     


    Best regards,

     

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


    Best regards,