Hey Justeen ! You're not alone, I saw a number of users have reported intermittent issues when connecting Power BI to Planview AgilePlace via OData and their REST API, especially when it comes to scheduled refreshes in the Power BI Service.
The OData endpoint can be quite slow, especially with larger boards or historical data. This often results in gateway timeouts.
If you're using basic auth or an API token, tokens sometimes expire or get revoked without notice. This results in silent failures.
the API returns partial or stale data depending on load or board structure.
Try to limit the data you pull by using filters ($filter, $top, $select) to reduce the dataset as much as possible during initial load.
Incremental refresh (if available in your Power BI tier) helps with large historical datasets.
Offload the heavy lifting to Power BI Dataflows and only connect the final data to your report.
Proud to be a Power BI Super User !
Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
