Forum Discussion

Dhyey29's avatar
Dhyey29
Frequent Visitor
3 years ago

Logs for API calls made with Power query

We are using Query Editor to write a query to fetch data from vendor using REST API call. On refresh, when the query executes, it gets stuck in infinite execution. The same REST API call works with p...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Dhyey29 ,

A PowerShell sample is available to help you learn how to filter and retrieve Power BI activity log events. All code fragments and scenarios are annotated with how-to instructions and common gaps or issues to watch out for. Two scenarios are covered:

  • Retrieve a list of users for specific app.
  • Retrieve a list of users for direct report sharing.

You must meet the following requirements:

More details: Access the Power BI activity log - Power BI | Microsoft Docs

 

I have also found a similar post, please refer to it to see if it helps you.

Solved: power bi log files - Microsoft Power BI Community

 you could go to File—>Option and Settings—>Options—>Diagnostics—>tick the Enable tracing —> Open traces folder, then you will find the Power BI log files.

 

If it still does not help, please provide more details.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Dhyey29's avatar
    Dhyey29
    Frequent Visitor
    3 years ago

    Hi Anonymous,

    We tried looking at the diagnostic logs generated by Query Diagnostics - https://docs.microsoft.com/en-us/power-query/querydiagnostics, but we are only able to get the URL and Request query. Is there any way we can get the actual response obtained from the API call, so we can use it to debug our issue?

      • Dhyey29's avatar
        Dhyey29
        Frequent Visitor
        3 years ago

        Hi Anonymous,

        We tried looking into the Audit logs and the Power BI Activity logs as well, but we only get the logs related to user activities performed on the Power BI Service platform. We are looking for logs regarding the API calls made through the Power BI query specifically - the request, response body, and status codes which would help us in troubleshooting any issues with the API calls.

    • jarmesb's avatar
      jarmesb
      Frequent Visitor
      1 year ago

      Best to use the fiddler application to see the responses.