Forum Discussion

zelalakyol's avatar
zelalakyol
Frequent Visitor
3 years ago

Get Power BI Logs with Api

We want to import Power BI logs to synapse analytics using API. We followed the steps in article but were only able to get a limited number of logs (like 24-31 or 36). However, we normally expected 2000+ logs to arrive. Why might this be the case, do you have any advice?

Also, is there a way to get the power BI logs instantly to synapse sql?

 

Following Article: Copy and transform data from and to a REST endpoint - Azure Data Factory & Azure Synapse | Microsoft Learn

 

Thanks

Need Help

2 Replies

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    3 years ago

    Hi. I'm not an expert on data factory or pipelines but the problems of limited number of logs sounds like the configuration you have is not solving the pagination. By default the API will response on a limited amount of logs, like 25 or 30. At the end of the response it has a URL like "next" or "continuationToken". That would be the next URL to request in order to continue getting the data. It looks like that's not working.

    I don't think there is an app to do it instantly. I can say there are libraries to read the PBI Rest API. I know SimplePBI (python lib). That library has a request for get activities that solve the pagination automatically. You can just add the day you want to extract and that's all. 

    I hope that helps,

    • zelalakyol's avatar
      zelalakyol
      Frequent Visitor
      3 years ago

      Hi,

      Thanks for helping but I could not understand how change limit. Where should I add the next URL? How can I check that it is working correctly? Plese help me about this.