Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

createing web url columns from azure devops backlogs item

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!

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , I think you need to have a measure like

 

measure = "https://<URL>?item="& max(Item[Item])

 

if column is possible then

measure = "https://<URL>?item="& (Item[Item])

Anonymous
Not applicable

@amitchandak Hi and thanks for your response , I did try the measure, but the resulting wrong URL. 

I try it like that measure = "https://<URL>?item="& max(Item[Title]) and it return error URL.

And I have about 1500 items that I bring from azure devps and thoses item updates daily as well. What I need is create a hyperlink for each item so that when I select one item from power bi it takes me to the correspondig item in devops?

Anonymous
Not applicable

@amitchandak do you have any idea can help me to get the backlog items link from azure devops?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.