Hi, Just updating this thread @v-yanjiang-msft, @cpwebb - I have still not found a solution to this. Is there somthing that can be done in the Power BI Service? Our query works perfectly well in Power BI Desktop and I don't know why the Service would be different, that it cannot refresh the data in the same way. With our query, when I can click on Refresh within the Power BI Desktop and it refreshes but in the Power BI Service, if I click on Refresh to refresh the dataset - it fails. Have either of you been able to get data from Azure Devops, where their are custom columns and multi row text columns? We have even tried simplifying things in ADO and now only use Feature to track everything, instead of having User Story children.
We won't be able to use contom connectors, I didn't seem to need to from my desktop and the OAuth2 works. Would truly appreciate assistance on this. I tried using just OData but just not getting the fields I need (green, yes - red, no) but I do get them with our query, no problem, except when published to the service.