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
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.

    • Mikes2nd1's avatar
      Mikes2nd1
      Helper I
      2 years ago

      The API calls with be an Azure admin event. Not in the power bi user event logs.  You still wont get the full detail I believe though. That would require you to use like postman to test before hand.