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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
chintu9494
Frequent Visitor

How to add Hyper URL link of Different SharePoint sites to Power Bi table item??

I have a project sharepoint list that is collection of all different project sharepoint sites that i have. I have table in power bi with those project names, i want to be able to add the different project SharePoint site links as Hyperlink in Power BI dashboard so when I click on that Hyperlink it will open the project sharepoint site

 

Below given are sample URL of project sites, the one highlighted in blue text is the dynamic item that keeps changing

 

https://SharePoint Site/Project Name/Home.aspx

https://sharepoint.com/sites/Project_portal/pmo-mgdwrk-XpertDocProofofConcept/SitePages/Home.aspx

https://sharepoint.com/sites/Project_portal/pmo-mgdwrk-DocumentCentre/SitePages/Home.aspx

https://sharepoint.com/sites/Project_portal/pmo-prj-JSAngularUpgrade/SitePages/Home.aspx

 

The table in Power BI looks like this where when i click on project name it should open the above project sharepoint sites

 

Project Name
XpertDoc Proof of Concept
Document Center
JS Angular Upgrade

 

 

Thank you

Chintu

 

 

1 REPLY 1
vicky_
Super User
Super User

First, you'll need to add another column to get the project site url part, such as:

Project NameDynamic URL Part
XpertDoc Proof of Conceptpmo-mgdwrk-XpertDocProofofConcept
Document Centerpmo-mgdwrk-DocumentCenter
JS Angular Upgradepmo-prj-JSAngularUpgrade


You can use a DAX formula to give you the correct link:

 

URL = "https://sharepoint.com/sites/Project_portal/" & SELECTEDVALUE(Table[Dynamic URL Part] & "/SitePages/Home.aspx"

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.