Forum Discussion
add URL to table (Items url)
Hello dear community,
I need help to constructing an URL for my backlog items in power bi desktop. In my data I don,t have any URL column so I guess I need to create a URL columns alt measure, but how?
I'd like to create a hyperlink for each item so that when a user selects one it the corresponding item in devops will opens.
I,ll be more greatful if someboody can help me!
When you retrieve the workitemid from Azure DevOps (via an Analytics View or oData), it is quite easy to enable the link.
Simply add a calculated column, e.g.
Web URL = "https://dev.azure.com/<azure devops org>/<azure devops project>/_workitems/edit/"&[workitemId]
Change <azure devops org> and <azure devops project> to your azure devops information and [workitemid] is the reference to your work item id column.
When adding your work item id to a table visual or similar and link the Web URL to the cell info, clicking on the work item id opens the work item in Azure DevOps.
The Web URL can be enabled by:
- selecting the table,
- Set apply settings to work item id (the column in the table)
- open the Cell elements accordion in the visual styling
- set Web URL to Yes and select the "fx" button
Some settings might be a bit different depending on the PowerBI Desktop version you use, but the process is the same.
If you want to do it in power query instead of a calculated column, adding the table would be something like this:
#"Add URL" = Table.AddColumn(<previous query step>,"Web URL", each "https://dev.azure.com/<azure devops org>/<azure devops project>/_workitems/edit/" & Number.ToText([Work Item Id]))
Applying the url in the visual will remain the same.
Hope that helps you on your way.
4 Replies
ferryvResolver II
When you retrieve the workitemid from Azure DevOps (via an Analytics View or oData), it is quite easy to enable the link.
Simply add a calculated column, e.g.
Web URL = "https://dev.azure.com/<azure devops org>/<azure devops project>/_workitems/edit/"&[workitemId]
Change <azure devops org> and <azure devops project> to your azure devops information and [workitemid] is the reference to your work item id column.
When adding your work item id to a table visual or similar and link the Web URL to the cell info, clicking on the work item id opens the work item in Azure DevOps.
The Web URL can be enabled by:
- selecting the table,
- Set apply settings to work item id (the column in the table)
- open the Cell elements accordion in the visual styling
- set Web URL to Yes and select the "fx" button
Some settings might be a bit different depending on the PowerBI Desktop version you use, but the process is the same.
If you want to do it in power query instead of a calculated column, adding the table would be something like this:
#"Add URL" = Table.AddColumn(<previous query step>,"Web URL", each "https://dev.azure.com/<azure devops org>/<azure devops project>/_workitems/edit/" & Number.ToText([Work Item Id]))
Applying the url in the visual will remain the same.
Hope that helps you on your way.
Hi Anonymous ,
Please check the similar post:
Hyperlink in Power Query Editor - Microsoft Power BI Community
1.In Power BI Desktop:
On Data tab > Modeling menu> Properties segment
Select Data Category as Web URL from thedrop down menue.
2.In Excel
In Excel, the same option is under Power Pivot -> Manage Data Mode -> Advanced -> Data Category
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.