Report server, authentication issue with Azure DevOps data
Hi, I have built a Report that uses data from Azure DevOps (Analytics Views) and published it to the Report Server of my company. I was able to configure it, refresh it several times per day and have it running for a few months until this week. I needed to modify something in the report and when I published the new version I kept getting the error message I have tried all options under Edit Credentials but the error message I keep receving is the one below: Activity ID: 11dd2d5e-3dd8-43e3-893e-74b606199b29 Request ID: a05f21c2-7a42-9abd-125d-d32bb4dacdda Status code: 400 Time: Thu May 19 2022 09:36:32 GMT+0200 (Mitteleuropäische Sommerzeit) Service version: 13.0.18218.51 Client version: 2205.1.11282-train Cluster URI: https://wabi-north-europe-g-primary-redirect.analysis.windows.net/ Can anybody help please?
How to deploy a pbip file from one workspace to the other through Azure DevOps?
Hi, I have this requirement of CI CD. I need to use the pbip files and then establishing the CI process followed by deployment. Now these deployment pipeline needs to be created using DevOps and by using these pipelines, one should be able to deploy the dashboard from Dev To Test and then to Prod workspaces. I tried using PowerBI Automation tools and PowerBI Actions extension but I don't really know how to publish a pbip file from one workspace to another workspace using DevOps. In short, I need to automate this entire dashboard deployment process. Kindly advice.. Many thanks in advance
Azure Devops Server / Scheduled Refesh
Just upgraded the report server to Sept 22 and whilst the Azure Devops Server connector is out of beta now it still doesn't allow scheduled refresh. does anyone know what version this is supported in? or if there are any plans to support it? alternatively does anyone have a workaround for scheduling refreshes of data from ADO? thanks.
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.
