Connect Azure DevOps to SharePoint Online Site with Power BI Connectors
Power BI connectors allow you to connect to your Azure DevOps Project and visualize the Work Items data in your reports. This helps you create insightful reports that can make tracking and decision making easier. The powerful interactive reports created on Power BI with this data can help you in effective management reporting, linking and connecting data from other sources such as your project management tools and all data view at a single place.?
?
Connect to an Analytics view?
Azure DevOps Analytics view helps to get the Azure Boards data based on the filters to a Power BI report. It provides few default views and option to create your own custom views.?
?
Once the Analytics view has been enabled and you are ready with the views, follow the below steps to connect it in the Power BI report:?
?
2. Provide the Organization and Team Project on the Dialog box and Click Ok?
After you clicked on OK, selected the two views? created.?
Creating a burndown chart?
As part of the sprint review dashboard, I decided to create two pages in a Power BI report. One to represent a burndown chart and the other to show a dynamic page showing all the backlog items worked on. You can extend this by adding other things like a velocity chart. In addition, you can show a pie chart of all the items based on their different tags.?
Embed a report web part in SharePoint Online?
?
The Power BI report web part for SharePoint Online allows you to embed interactive Power BI reports in SharePoint Online pages.?
?
领英推荐
When you use the Embed in SharePoint Online option, the embedded reports respect all item permissions and data security through row-level security (RLS), so you can easily create secure internal portals.?
?
Embed your report?
To embed your report into SharePoint Online, you need to get the report URL and use it with SharePoint Online's Power BI web part.?
?
Get a report URL?
Open a report in the Power BI service.?
On the File menu, select Embed report > SharePoint Online.?
?
Copy the report URL from the dialog box.?
Add the Power BI report to a SharePoint Online page?
in SharePoint Online, select Pages > + New > Site Page to create a new modern site page.?
Select Add report.?
Paste the previously copied report URL into the Power BI report link field. The report loads automatically.?
?
?
Walla – Have Fun! :)?