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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Dhyey29
Frequent Visitor

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 postman. We need to analyse this issue with Power BI logs. We followed the link to enable tracing but were not able to get the logs related to the Query execution. Could you please help us to find those logs?

6 REPLIES 6
Anonymous
Not applicable

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.

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?

Best to use the fiddler application to see the responses. 

Anonymous
Not applicable

Hi @Dhyey29 ,

Here is a blog about how to Export activity logs.

How to view the frequency of user usage for all wo... - Microsoft Power BI Community

 

Hope it would help you.

 

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.

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.

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.