Azure DevOps via oData Not Refreshing Entire Dataset using Power BI Service Scheduled Refresh
So we are pulling data from Azure DevOps into Power BI via oData because that is the only way to bring "BoardColumn" into Power BI.
ADO has about 230 items in it, and when I refresh using Power BI Desktop it pulls in the entire dataset. However, when the online service runs a scheduled refresh, it doesn't bring in all the data (or error out). This most recent time it brought in only 9 (verified by downloading the pbix and looking at the actual table in the file).
Does anyone know why that would be happening? What can be done to fix it?
Happy to try that. I have probably like 3-5 odata queries, I'm assuming I need to add that to all of them?
But don't I not want it to time out on the online service? If one fails, wont the entire refresh fail? To be clear, it refreshes on the desktop just fine (see all 232 items) but the online service is all over the place: