Unable to Setup Refresh Schedule on PBI RS for Azure DevOps Server Connection
Hello, Overview I am currently having trouble figuring out how to setup a refresh schedule for an Azure DevOps Server connection for a dashboard in PBI RS. Just to clarify again, both ADO and PBI are on-premise, so features related to services are unavailable. Problem Within Power BI RS, under the dashboard I want to set up the schedule for, the Data Sources is greyed out and I get this message in Scheduled Refesh: Details Here are the versions of everything I'm working with: Power BI Desktop May 2023 Power BI Report Server May 2023 Azure DevOps Server 2020 My current connection is through the dedicated ADO Server source: Within Power BI Desktop the refresh works flawlessly, and any changes made in ADO are instant to PBI. Unfortunately once in Power BI RS, I can't even view the source which results in no refresh schedule available. Any help will be greatly appreciated!
How to analyze work item history from Azure DevOps in Power BI?
I'm currently trying to create extensive Power BI report for Azure DevOps work items. I got direct access with SQL to analytics tables and views. I have already checked the official documentation here, but most of the sample reports for historical data pretty much refers to WorkItemSnapshot table. I also did some experiments with WorkItemSnapshot but that would force me to go with daily level reporting and I would be also interested of weekly or sprint level history. Also even with direct SQL call and some WHERE limitations it was really slow for longer periods (we got lot of stuff on db). I thought that since that table is anyway some sort of CROSSJOIN between dates and WorkItemRevision table, probably I could directly fetch the full table on use some DAX magic to achieve much more performant and flexible end result. Only thing is that I don't have enough of that magic and that is why I'm here. Some measures I'm looking for: Total efforts: daily, weekly, sprint, PI Done efforts: daily, weekly, sprint, PI Items moved out of sprint during sprint Items moved to the sprint during sprint To start with total efforts we would need sum of effort for last revision of each work item in current filter context, say single date. Probably we haven't modified work item on that date so we would need to fetch last revision before that date. Here is simplified example of WorkItemRevision data for someone who is not familiar with Azure DevOps datamodel: Hopefully you could throw in at least some comments which direction I should look for.
