Forum Discussion
How to add SharePoint link as hyperlink to column
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.
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!!!
Hi shyamily_123
If I understand it correctly, all projects are in the same sharepoing list. So if we want to redirect to a specific row in the sharepoint list, we need to be able to identify every row through the URL.
Based on my test, every item in a Sharepoint list has a unique link for access. However I'm not sure if we can export these links along with all columns of items. So the next step is to find ways to get these links in bulk. However, I haven't found the solution yet.
Best regards,
Jing
Hi v-jingzhang ,
Thanks. Now we are trying to auto populate url of each row from SharePoint list using dyanmic formulas like DAX or calculated measure. When new raw is inserted then sharepoint will auto populate that row's url. Is there any solution for that other than using Power app?