cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cammarcz Helper III
Helper III

Add link back to data source

The report I am currently working on is bringing in data from a SharePoint site. One of the columns is "Project Title". What I am trying to do is create a link from the "Project Title" values in the Power BI table back to the corresponding item in the SharePoint list. Is this possible? Thank you in advance for any help or advice. 

4 REPLIES 4
Shawn_Fitz
Frequent Visitor

Re: Add link back to data source

Depending on how you are trying to link them,

You could try by naming the columns you want to link from both of your sources the same name,

and in the edit queries page and append the two tables.

cammarcz Helper III
Helper III

Re: Add link back to data source

I'm not sure you understood what I am trying to do. I want to be able to click on a value in the "Project Title" column and have it open the corresponding item in the SharePoint list which is the data source for the Power BI report. I am not trying to link two tables within Power BI.

Dobby_Libr3 Resolver I
Resolver I

Re: Add link back to data source

Hi, 

 

I use this in nearly all my reports so people can go back to the source. I'm not sure how sharepoint works as I use  salesforce but I just create a new column and have the base URL mixed with the unquie ID.

 

This then directs users to a specific record in salesforce

 

link.PNG

 

Hope it works out for you

 

Rob 

cammarcz Helper III
Helper III

Re: Add link back to data source

That would work perfectly, but the URL for the SharePoint item does not include the project title and there isn't any discernable pattern to the URLs.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors