Forum Discussion

Dribblej's avatar
Dribblej
Frequent Visitor
3 years ago
Solved

Graph API Error after 18 months of working flawless

Hello everyone, For many many months I have had an azure logic app created, with a power automate flow, that would allow me to query the graph api for users on my microsoft tenant. I now recieve a...
Need Help
  • Dribblej's avatar
    Dribblej
    3 years ago

    For anybody who runs into 504 timeout calling graph api through this method into power bi here is what I did to fix the issue:

    - filtered query on GET request to only use the fields I needed along with a true filter statement
    - Its still odd to me that for roughly 2000 users I was hitting a timeout issue. 
    - The Fix I employed gets down to about a 80 second query time, just below the 100 second timeout threshold. 
    - Using graph explored this data takes 2 seconds to grab. 
    - Im not sure why it takes so long using the HTTP GET request with power automate. 

    If you have any solutions to speed up these type of queries into the graph api using power automate and an azure logic app please leave a comment for all to learn from. 

    Cheers

Dribblej's avatar
Dribblej
Frequent Visitor
3 years ago

For anybody who runs into 504 timeout calling graph api through this method into power bi here is what I did to fix the issue:

- filtered query on GET request to only use the fields I needed along with a true filter statement
- Its still odd to me that for roughly 2000 users I was hitting a timeout issue. 
- The Fix I employed gets down to about a 80 second query time, just below the 100 second timeout threshold. 
- Using graph explored this data takes 2 seconds to grab. 
- Im not sure why it takes so long using the HTTP GET request with power automate. 

If you have any solutions to speed up these type of queries into the graph api using power automate and an azure logic app please leave a comment for all to learn from. 

Cheers