Forum Discussion

gemcityzach's avatar
gemcityzach
Icon for Helper IV rankHelper IV
2 years ago
Solved

Preserve SharePoint List absolute URL in report

Hey folks, I'm building a report that brings in various fields from a SharePoint list. One of those fields is the URL to the specific SharePoint list record.   In the list the record is stored cor...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi gemcityzach 

    You can use this 

    = Table.TransformColumns(#"Changed Type", {{"Link_to_record", each if _="" then "https://sharepoint.companyname.com/teams/XXXXX" else "https://sharepoint.companyname.com" & _, type text}})

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi gemcityzach 

 

We can't affect how data is brought from SharePoint List to PowerBI, but you can transform the data with Power Query. As lbendlin suggested, you can add the base URL part as prefix string to the relative URL column. After that, load the data into Power BI Desktop and set the URL column's data category to Web URL, thus the URLs can be clickable in the report. Here is a blog for your reference: 

Add Prefix and Suffix to a Text in Power BI: Generate Country Images and pages - RADACAD

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!