Forum Discussion
How to add SharePoint link as hyperlink to column
Community SupportHi shyamily_123
You need to prepare the URLs of those projects in a table column in advance. Then add this URL column to a table or a matrix in the report. Select the URL column, on the Column tools tab, select Data category > Web URL. You can refer to the following article to get detailed guidance.
Add hyperlinks (URLs) to a table or matrix - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi,I need a dynamic solution because here daily new projects are being added. So it's not possible to add link for each project name.
My requirement is when i click on a project name it should redirect to that exact row in SharePoint.
Above solution is useful when i want to open that sharepoint list. Here that's not the case, i want to open that sharepoint site and the row that i clicked on power bi table visual.
- v-jingzhang
Hi shyamily_123
Are these projects in the same sharepoint site? Do they have a similar URL format? If they do, you can add a column to get the dynamic URLs by concatenating the basic URL section and project name column. For exmaple,
URL column = "https://xxxxxxbasicURLxxx/" & 'TableName'[Project Name]Best regards,
Jing
v-jingzhang Yes,these projects are in the same sharepoint site . Now i have 180 projects in that share point. My dashboard has a table visual which contains all columns and rows present in the sharepoint list. Client want to open sharepouint list when he click on any project name from project column.We tried with hyperlink , it opens the sharepoint list but what we need is when he click on any project name in the table visual this hyperlink should redirect to that exact row in sharepoint list.
Will it possible with power bi ?
Please help!!!
