Zürich - 51st Fabric User Group [ONLINE]
Dear Data Wizards We are looking forward to inviting all of you to our next meetup. This time in online Mode! Topics: What's New - Kristian Professional Developer Experiences in Power BI Microsoft Fabric Part 5: Deep Dive into Data Activator - Denis The session will be recorded. Professional Developer Experiences in Power BI Developer mode seamlessly integrates developer-centric features directly into Microsoft Power BI Desktop. This advancement empowers users to effortlessly implement source control for their work, thereby boosting efficiency and enhancing the maintenance of Power BI projects. When combined with Azure DevOps and Fabric Git Integration, Developer Mode opens up unprecedented collaboration possibilities, facilitating the establishment of robust Continuous Integration/Continuous Deployment (CI/CD) pipelines. These pipelines not only improve the reliability of Power BI projects but also enable scalability, ultimately elevating the development and collaboration experience to new heights. Join me to explore how these powerful tools can transform your Power BI development experience. Good to know We want this group to be a safe environment that encourages open discussion, exchange of ideas and problems you may face. Therefore, we kindly ask that no members will leverage the information for unsolicited acquisitions of new customers or projects. This group builds on trust, and without it we cannot learn from each other and excel on this topic. Want to be a presenter? We are always looking for new speaker. If you are interested and would like to show something to the Power BI Meetup Group please feel free to contact us!
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.
