cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
ZowieS
Regular Visitor

Sharepoint Online List - Direct link to item

Hi,

 

Do anyone know were I can get the direct link to an item in a Sharepoint Online list fin Power Bi?

I want to add those like to each items so the conumsers can click in the link and get direkted to that item in the list.

 

I've google around and I have been sitting for awhile in Power Bi Desktop and looked around but I haven't found anything.

 

Anyone have any idé?

 

Thanks!

4 REPLIES 4
ZowieS
Regular Visitor

@amitchandak & @rubinboer,

 

Thank you for your help!

 

I'm sorry but you are a bit head of me here 😅

I still havn't found the URL in the dataset of all the colums I get when I connect to a Shrepoint Online List.

Were you able to add a link to each item by ID? If so could please explain what you did as i would like to also do this. thanks

rubinboer
Resolver I
Resolver I

hi there try this.

create a measure

SP ItemHyperLink =  SELECTEDVALUE('TableWithUrl'[ColumWithUrl'])

ColumnWithUrl is the link that you want to direct to in sharepoint

 

Add a button

Switch the action to on

Configure Web URL : Field Vaue and Based on URL is the measure SP ItemHyperLink

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors